Microsoft Access 2007 Training Course

The Microsoft Certified Application Specialist Certification, (MCAS) recognizes business professionals who have demonstrated expertise in Microsoft Office 2007. Our 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, our course follows the approved Microsoft course curriculum, ensuring you receive the training and knowledge needed to succeed.  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

Exam 77-605 - Access 2007 Course Summary