|
|
|
|
|
|
Tuition:
$295.00 per student |
Length: 1 and 1/2 days |
|
|
Synopsis:
Accelerated Introduction to Microsoft Access course for experienced Microsoft Office users. Corresponds roughly to material required for MOUS proficient level plus some additional material. Covers tables, external data, queries, forms, reports and macros. Students will create a working database application during this intensive, hands-on course. This database can be tailored to the needs of custom groups or private training students. No prior knowledge of Access assumed although students should be proficent with standard Microsoft Office. Available in 2003 and 2007 versions.
|
|
Formats:
Corporate groups (min. 2 students) at your facility or ours in San Juan Capistrano, Orange County, California. Single individuals may arrange a private class billed hourly at private training rates. Not offered via pre-scheduled classes.
|
|
Scheduling:
Group and private training conveniently scheduled by arrangement.
|
|
Group
Discounts:
Substantial - see FAQ's.
|
|
|
|
| Session 1 | Tables and Queries | 4.0 Hours | | |
- Creating an MS Access database
- Designing tables
- Exporting tables to Excel and text files
- Importing files
- Creating Permanent Links between Tables
- Creating simple and multi-table queries
- Calculated fields and concatenation
- Summary and parameter queries
- Using the expression builder
| | | Session 2 | Reports and Forms | 3.0 Hours | | |
- Creating reports
- Formatting your report.
- Adding graphics.
- Subreports and one-to-many reports
- Creating forms
- Formatting your form
- Adding subforms to a main form
- Subtotals
- Using the builders and wizards.
| | | Session 3 | Automating Tasks | 2.0 Hours | | |
- Action queries.
- Macros
- Using control wizards.
- Switchboards
| |
|
|
References:
Please see the book list for references you may want
to have available. We are an Amazon.com affiliate
and you may purchase your Microsoft Access books through this
site.
|
|
Materials:
Students will receive a notebook with a printout of all slides used in their class and a training certificate.
|
|
Location:
Classes are normally held on-site at your facilities
or at our location in San Juan Capistrano, Orange
County. We do, however, offer other alternatives.
Please see FAQ's
if interested. We also travel beyond Southern California.
|
|
|
|
