This course builds on the skills and concepts taught in Access 2007: Intermediate. Students will learn how to query with SQL; create crosstab, parameter, and action queries; create macros; import, export, and link database objects; interact with XML documents; create hyperlink fields; optimize, split, and back up databases; password-protect and encrypt databases; and set Access options and properties.

This course will help students prepare for the Microsoft Office Specialist exam for Access 2007 (exam 77-605). For comprehensive certification training, students should complete the Basic, Intermediate, and Advanced courses for Access 2007

To ensure the successful completion of Microsoft® Office Access 2007: Level 3, we recommend completion of the following Knowledge Transfer courses, or equivalent knowledge (familiarity with basic and intermediate features of Access tables, relationships, queries, forms, and reports) from another source:

Microsoft® Office Access 2007: Level 1

Microsoft® Office Access 2007: Level 2