Microsoft Access

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.
* When do I use Microsoft Access as a Solution?
* What are Relationships and when must I use them?

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

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

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

* 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

* Creating a Macro & Adding it to a Form

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

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