• • 
•  
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 

Microsoft Access 2007

GES 803 -- 35 hours

Course Objectives

By completing the Microsoft Access 2007 course, students will:
• 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: calculate with DateDif(),Left(), and IIF(), 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, as well as publish an Access report to Word, and optimize a database for multiple users.

Students who wish to prepare for the Microsoft Certification Exam 77-605: Using Microsoft® Office Access 2007 will find beginning lessons that demonstrate these required MCAS topics.



---