Microsoft Office Specialist (MOS) Access 2007: Microsoft Office Access
2007 Specialist

Product Description

Overview

This certification class provides a complete instruction solution to fully prepare students to achieve Microsoft Office Specialist (MOS) Microsoft Office Access 2007 accreditation. It concentrates on getting delegates from knowledgeable to ?exam ready? in a 2 day class. The class is aimed at delegates who already have the raw skills to take the exam, but wish to hone those skills & practice with assistance from an experienced MOS qualified instructor, prior to taking the exam.
Please note this is the only level of exam available for Microsoft Access 2007. MOS exams are also available for Word, Excel, Power Point & Outlook 2007.
This is a replacement class for the Access 2007 MCAS in a Box 2 day class (DACMCAS).
Included are
?2-days Instructor Led Instruction using MOS Official Classware
?MOS Practice Exam Voucher
?MOS Exam Voucher
? Free Exam Re-take (where required)
During the 2 day class you will cover the following topics to prepare you for exam 77-605: Using Microsoft Office Access 2007. During the class, you will have the opportunity to test your knowledge & complete a full practice exam before taking the final exam at the end of day two.
Structuring a Database
? Define data needs & types
? Define & print table relationships
? Add, set, change or remove primary keys
split databases
Creating & Formatting Database Elements
? Create databases
? Create tables
? Modify tables
? Create fields & modify field properties
? Create forms
? Create reports
? Modify the design of reports & forms
Entering & Modifying Data
? Enter, edit & delete records
? Navigate among records
? Find & replace data
? Attach documents to & detach from records
? Import data
Creating & Modifying Queries
? Create queries
? Modify queries
Presenting & Sharing Data
sort data
? Filter data
? Create & modify charts
? Export data
save database objects as other file types
? Print database objects
Managing & Maintaining Databases
? Perform routine database operations
? Manage databases