Microsoft Access
Advanced

This product is vast and you will gain even more skill as a designer in this class. Take the knowledge gained from the Introduction and Intermediate classes and then expand on that to manipulate data more intricately. Once data is combined from multiple sources, create calculations with them for mathematical reporting. Setup forms to "lookup" data from multiple tables based on a known piece of information, and incorporate the other packages within the Office Suite (eg. Excel & Word) for data sharing and reporting. Automate processes with macros and code for better performance and pull a complete system together!
Tables
* Importing and Linking Tables
* Using a Split Database
* Updating Linked Tables
* Table Relationships

Queries
* Advance Summary Queries
* Crosstab Queries
* Join Types - Equi, Right Outer and Left Outer Joins
* Creating Queries to be used by Forms

Forms
* Advanced Form Layout
* Calculations on a Form
* Auto Populating Lookup
* Advanced Controls
* Using Macros with Events

Reports
* Advanced Report Layout
* Calculations on a Report
* Advanced Controls on a Report
* Snaking (Multi-Columned) Reports

Extras
* Sending a Table to Merge with Word
* Compact and Repair
* Database Backup
Cost:$254/person (+ hst) includes workbook, certificate & 2 month hotline
Guarantee:Repeat at no charge up to 2 months later! (minimum class size required)
Duration:1 day(s) 9:00 am - 4:30 pm or 2 evenings 6:00 pm - 9:00 pm
Prerequisite:We recommend a good knowledge of Windows & Access Intermediate