Course Info

MA2007-3 - Microsoft Access 2007: Advanced

Categories Applications Training, MOUS Certification Training, Microsoft Access Training, Database Training

Duration 1 day (7 hours)

Pre-requisites To have equivalent knowledge of Access 2007: Introduction and Access 2007: Intermediate levels, that is familiarity with basic and intermediate features of Access tables, relationships, queries, forms, and reports.

Courseware MA20073-TL (208 pages)

Price $195

Notes

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; work with XML documents; work with Windows SharePoint Services; optimize databases; password-protect and encrypt databases; set Access options and properties; create hyperlink fields; and use Outlook 2007 to update data. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Basic, Intermediate, and Advanced.

Querying with SQL
      SQL and Access
      Writing SQL statements
      Attaching SQL queries to controls
Advanced queries
      Creating crosstab queries
      Creating parameter queries
      Using action queries
Macros
      Creating, running, and modifying macros
      Attaching macros to the events of database objects
Advanced macros
      Creating macros to provide user interaction
      Creating macros that require user input
      Creating the AutoKeys and AutoExec macros
      Creating macros for data transfer
Importing, exporting, and linking
      Importing objects
      Exporting objects
      Interacting with XML documents
      Linking Access objects
      Working with Windows SharePoint Services
Database management
      Optimizing resources
      Protecting databases
      Setting options and properties
Internet integration
      Hyperlink fields
      Working with Outlook 2007