Microsoft Access

Introduction to Access (6-7 hours)
This class covers: Planning your database; creating new databases; entering and editing data; querying your database; creating and using basic forms; creating and printing basic reports; customizing fields and tables; managing data and files.
Introduction to Windows or work experience is a prerequisite.

Intermediate Access (6-7 hours)
This class covers: creating consistent data formats, conditional formats for positive, negative and null values; using input masks, default values, restricting entries, requiring data entry, preventing duplicate entries, creating lookup columns; managing data using smaller, related tables; adding useful feature to your forms (lookup lists, formats, date stamps); creating labels; creating calculated fields in a report; creating reports that group data, using access macros; creating a switchboard form; managing your database.
Introduction to Access or work experience is a prerequisite.

Advanced Access (6-7 hours)
This class includes: making your input form more user-friendly; updating tables: by substituting text or selected portions of fields, with calculated expressions, based on values in another table; analyzing a table, analyzing database performance, determining database characteristics using the Documenter, using OfficeLinks to analyze data with Excel and create reports using Word; creating crosstab queries and reports, subreports, subforms; filter using parameters, custom dialog boxes and form filters; sharing a database with others.
Introduction and Intermediate Access or work experience is a prerequisite.