This course, created by Certified MOS Master Instructor Jennifer McBee, helps you prepare for the Access 2010 MOS certification exam (77-885). Review the five main areas of the Access 2010 MOS exam, including managing the Access environment, building tables, creating forms, creating and managing queries, and designing reports. Explore the MOS certification program, its cost, and its format and walk through each Access certification objective in detail. Get hands-on experience with free able practice files and take the challenges to test your skills. The course wraps with a full-length, 50-minute practice exam.

Topics include:


* Creating a new Access database
* Applying application parts
* Backing up a database
* Creating new tables and fields
* Sorting and filtering records
* Setting primary keys
* Importing data
* Creating basic forms
* Creating Access queries, including crosstab and multitable queries
* Creating Access reports