Office Certification Access Excel Outlook PowerPoint Word Vista Resources  
Description: The Microsoft Certified Application Specialist program is the only comprehensive, performance-based certification program approved by Microsoft to validate business computer skills using Microsoft Windows Vista® and Microsoft Office® 2007 productivity software: Excel, Word, Power Point, Access, and Outlook.

Objectives: At the end of The Beginning Guide to Microsoft Access 2007, the student will be able to: Use and design tables, forms, and queries in Microsoft Access, create Queries to find and select records by criteria, write and test update queries.

At the end of The Intermediate Guide to Microsoft Access 2007, the student will be able to: 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.

At the end of The Advanced Guide to Microsoft Access 2007, the student will be able to: 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, as well as publish an Access report to Word, optimize a database for multiple users.

Exam 77-605: Using Microsoft® Office Access 2007

Microsoft Certified Application Specialist (MCAS) reference topics