Access Level 3 (2003 or 2007)

Your current skill level has provided you with a solid foundation in the basic and intermediate tools for working in Access. You are now ready to extend your knowledge into some of the more specialized and advanced capabilities of this powerful and widely used data management program.

Performance-Based Objectives:

Upon successful completion of this course, students will be able to:

restructure an existing set of data to improve the design of a database.

use a variety of techniques to summarize and present data with queries.

create and revise basic Access macros.

create macros that improve data entry efficiency and integrity.

improve the effectiveness of data entry in forms.

improve the effectiveness of data displayed in reports.

maintain an Access database by using various utility tools.

create an Access Application

Excel Sessions:

If you're using Excel...

Many Excel users find great value in taking an Access course also. Excel's calculating skills are awesome but the data management and reporting tools are limited.

Access is just the opposite. Great data management capabilities, an easy to use report writer but a bit hard to use for complex calculations.

Why not get the best of both worlds.