Microsoft Certified Application Specialist – Access 2007

Who Should Attend: This course is designed for people wishing to formalise their knowledge with a recognised qualification.

Pre-Requisits: Delegates should have completed an Introductory to Access 2007 or a migration course in MS Office 2007 and be users of MS Access 2007.

Course Length: 2 days,with an exam in the afternoon of the second day.

Structuring a Database
Define data needs and types
Define table relationships
Create and modify primary keys
Split a database

Creating and Formatting Database Elements
Create a database
Create a table
Modify a table
Create fields and modify field properties
Create a form
Create a report
Modify the design of a report or form

Entering and Modifying Data
Enter, edit and delete records
Navigate among records
Find and replace data
Attach documents to and detach from a records
Import data

Creating and Modifying Queries
Create a query
Modify a query

Presenting and Sharing Data
Sort data
Filter data
Create and modify charts
Export data
Save a database object as another file type
Print a database

Managing a Database
Perform routine database operations
Manage a database