|
|
|
|
AIN104: Microsoft Access Reports and Forms
|
Course Links |
Practice Test
|
|
|
|
Tuition:
$245.00 per student |
Length: 1 day |
|
|
Synopsis:
Full day course covering reports and forms. Includes forms, sub-forms, charts, unbound forms, reports, sub-reports and using queries as data sources. Uses Wizards, Designers and the Expression Builder. Students should have a basic working familiarity with Access.
|
|
Formats:
Corporate groups (min. 2 students) at your facility or ours in San Juan Capistrano, Orange County, California. Single individuals may take a scheduled class or arrange a private class billed hourly at private training rates.
|
|
Scheduling:
Group and private training conveniently scheduled by arrangement.
|
|
Group
Discounts:
Substantial - see FAQ's.
|
|
|
|
| Session 1 | Reports | 3.0 Hours | | |
- Data sources including queries
- Bound reports
- Simple listing reports
- Page layout
- Calculated fields
- Grouped Reports and summary fields
- Sub reports
- Using the expression builder
- Adding graphics
| | | Session 2 | Forms | 3.0 Hours | | |
- Data sources including queries
- Bound forms
- Calculated fields
- Affects of table relationships on form wizards
- Sub-forms
- Master-detail forms
- Tab control
- Charts
- Adding sub-totals to a form
- Using the expression builder
- Unbound forms
- Using unbound forms for report criteria
- Combo Boxes
- Finding and filtering Data
| |
|
|
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.
|
|
|
|
