The Microsoft Certified Application Specialist Certification, (MCAS) recognizes business professionals who have demonstrated expertise in Microsoft Office 2007. SmartCert's Access 2007 course provides students with the knowledge and skills that are needed to use the advanced software features, and integrate the Office programs with other software. When you pass the Access 2007 Exam 77-605, you achieve Microsoft Certified Application Specialist (MCAS) status in Access 2007.

As a Microsoft Certified Partner, SmartCert follows the approved Microsoft course curriculum, ensuring you receive the training and knowledge needed to succeed. SmartCert is so certain this course meets and exceeds the exam objectives, we guarantee you will pass your exam!

Learning segments

Access Basics

• Designing a Database
• Building a Database
• Non-Numerical Data Types
• Managing Table Data
• Filters and Queries
• Using Forms
• Producing Reports
• Create a Database
• Create a New Table
• Edit a Relationship
• Set Field Data Type
• Manage Table Data
• Filter a Datasheet
• Design a Query
• Create a Form
• Design a Report

Controlling Data Entry

• Finding and Joining Data
• Creating Flexible Queries
• Enhancing Forms
• Customizing Reports
• Sharing Access Data
• Create a Validation Rule
• Join Tables in a Query
• Create a Parameter Query
• Add Controls to a Form
• Create a Grouped Report
• Get External Data

Structuring Existing Data

• Writing Advanced Queries
• Creating and Using Macros
• Making Forms More Effective
• Improving Reports
• Setting Startup Options
• Database Maintenance
• Distributing and Securing the Database

Summary