The Microsoft Certified Application Specialist Certification, (MCAS) recognizes business professionals who have demonstrated expertise in Microsoft Office 2007. UCertifyOnline'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 IT Academy Program Member, UCertifyOnline follows the approved Microsoft course curriculum, ensuring you receive the training and knowledge needed to succeed.  UCertifyOnline is so certain this course meets and exceeds the exam objectives, we guarantee you will pass your exam!

 Course Duration: 3 Months

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

For More Information E-Mail us at sales@UCertifyOnline.com