Microsoft Access
Intermediate

This course is geared to designers who need to learn how to create more complex data entry forms, filters, and reports. You will learn how to relate data from different tables to eliminate redundancy and combine their elements on a single form, query, and report. You will modify the database for others to use and incorporate "user friendly" and "bullet proof" techniques via buttons on forms, calculated variables, update queries, and security. Macros will also be introduced to demonstrate the automation available for users.
Planning
* When do I use Microsoft Access as a Solution?
* What are Relationships and when must I use them?

Tables
* Creating Tables in Design View
* Creating a Lookup Table
* Setting Data Types and Field Properties
* Importing information from Excel to an Access Table

Relationships
* Relationship options (Referential Integrity and Join Types)
* Relationship types (one to one, one to many and many to many)

Queries
* Select query using related tables
* Using Crosstab, Make table and Update queries
* Using an Append query and Delete query to move information

Forms
* Creating a Form with a Subform
* Changing Form and Field Properties
* Form Controls (Labels, Search Box and Command Buttons)
* Creating a Menu Form in Design View

Macros
* Creating a Macro & Adding it to a Form

Reports
* Creating a Report with Related Tables
* Report Design and Properties
* Adding Calculations to a Report using the Count Function
* Adding Controls to a Report

Security
* Setting a Password on the Database
* Customizing the way the Program Starts & Limiting Options
Cost:$229/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 Introduction