The Complete Guide to Access 2007

Exam 77-605: Microsoft ® Office Access 2007
Online instructor and email support

This course also includes books, lesson plans, sample tests, and assessments.

Objectives:

The Beginning Guide to Microsoft Access 2007: Use and design tables, forms, and queries in Microsoft Access, create Queries to find and select records by criteria, write and test update queries. 

The Intermediate Guide to Microsoft Access 2007: Create forms with subforms to represent one-to-many relationships, use criteria, parameters, concatenation, and operators in Query designs: calculate with DateDif(),Left(), and IIF(), improve report designs with Sorting and Grouping.

The Advanced Guide to Microsoft Access 2007: Link information and automate data entry, create a Search Form that uses a Combo Box to filter the records, use Microsoft Access and Word together in a Mail Merge,  publish an Access report to Word, optimize for multiple users.

Demonstrates these Microsoft Certified Application Specialist (MCAS) objectives for Access 2007