Target Audience: This scenario-based class provides experienced Microsoft Access users with a stronger relational database foundation. It brings home relational database concepts and teaches how to employ powerful techniques using Access in gathering, organizing, and reporting of information vital to your business. This course is designed for experienced Access users.

Pre-requisites: Before attending this course, students must have the following pre-requisites:

• A basic understanding of relational databases.
• An understanding of Access tables, queries, forms and reports and a base knowledge of how they are used within an Access database.
• Experience creating Access macros and using them in forms.
• A working familiarity with standard Microsoft Office applications (such as Microsoft Outlook, Word, and Excel).

Purpose: After completing the course, students will be able to create solid relational database structures using Access for data integrity that is easier to maintain; import data of various formats from outside sources; utilize appropriate techniques for querying information in the Access database as various business needs arise; create consistent standard user interfaces for inputting data; generate powerful and flexible reports for management; describe the benefits that can be realized from the integration of Access with other Office 2003 applications.