MS Access - Level 3, CMP083

Master the intricacies of MS Access 2007 by using the new ribbon and menu tab interface. Use the Table Analyzer Wizard to check the integrity of data to correct data redundancy problems using Junction tables. Write advanced Queries to analyze and summarize data through matched and unmatched queries, crosstab queries and a new streamlined version of MS’s PivotChart and PivotTable features. Simplify tasks by expanding mastery of the use of Macros in Access forms using Macro Builder to enter expressions and criteria conditions. 

Prerequisites: Prerequisite: MS Access--Level I & II or equivalent experience.

Textbook: Purchase at the Rockville Campus Bookstore and bring to first class along with a USB Flash Drive/memory stick (at least 512 MB).

Classroom Hours: 10

Course Content

Lesson 1: Structuring Existing Data

Lesson 2: Writing Advanced Queries

Lesson 3: Simplifying Tasks with Macros

Lesson 4: Making Effective Use of Forms

Lesson 5: Making Forms More Effective

Lesson 6: Maintaining an Access Database