The Intermediate Guide to Microsoft Access 2007

Exam 77-605: Using Microsoft® Office Access 2007

Description: The Intermediate Guide to Microsoft Access 2007 demonstrates how to create forms with subforms to represent one-to-many relationships. The Query teachings show how to use criteria, parameters, concatenation, and operators: DateDif(),Left(), and IIF(). The report designs are enhanced with Sorting and Grouping. 

Who will benefit from this course? Students who want to learn how to design a database that enables uses to enter data successfully will appreciate The Intermediate Guide to Microsoft Access 2007 and the sample databases. Successful students will be able to create tables, forms, queries and reports that show one-to-many relationships.

Audience Description: Who should take this course?

The certification training is available to adult learners online in partnership with major colleges and universities. The audience for this course includes:

•  Office workers, managers, entrepreneurs, teachers, and military personnel who want to start using advanced skills immediately

•  Job training and professional development (WIA), as well as retired and unemployed people looking to expand their job possibilities

Course Prerequisites: Students who enroll in The Beginning Guide to Microsoft® Access 2007 course should have the equivalent of six months of hands-on computer experience. These students are proficient at file management: save, update, and backup. It is recommended that students complete The Beginning Guide to Microsoft Access 2007