Target Audience: The techniques learned in this course will enhance skills for gathering, organizing, and reporting vital business information and demonstrate the power of Access as a financial data management and analysis tool. This course is designed for people who use Access on a regular basis, and who are also experienced with Excel.

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 Excel and Microsoft Word).

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; utilize appropriate techniques for querying information in the Access database as various business needs arise; generate powerful and flexible reports for management; use VBA to create routines to automate simple repetitive tasks in Access Create; integrate their data with Microsoft Excel by using the built-in features of Access and by using VBA code.