|
|
|
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. |
Formats: Corporate groups
(min. 2 students) at your facility or ours in San Juan
Capistrano, Orange County, California. Single individuals may
take the scheduled AIN100A
and AIN100B
MS Access classes or arrange a private class.
|
Scheduling: Flexible. Group and
private training can be scheduled to suit your
needs. See calendar for scheduled classes.
|
Group
Discounts: 2-4 students
20%, 5-8 30%, >8 quote |
|
|
|
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 taught on-site at your facilities or at our
location in San Juan Capistrano, Orange County. We do,
however, offer a wide range of alternatives. Please see
FAQ's
if interested. We also travel beyond Southern
California. |
|
| |