Microsoft Access 2007 GES 803 » 120 hours
By completing the Microsoft Access 2007 program, you'll:
- Know how to use and design tables, forms, and queries
- Create queries to find and select records by criteria, and write, test, and update those queries
- Understand how to create forms with subforms to represent one-to-many relationships
- Learn to use criteria, parameters, concatenation, and operators in query designs
- Improve report designs with sorting and grouping
- Know how to link information and automate data entry
- Create a search form that uses a combo box to filter the records
- Know how to use Microsoft Access and Word together in a mail merge
- Be able to optimize a database for multiple users
If you wish to prepare for the Microsoft Certification Exam 77-605: Using Microsoft Office Access 2007, you'll find beginning lessons that demonstrate these required MOS topics here.