|
|
|
|
|
|
|
|
|
Tuition: $395.00 per student |
Length: 2 days
| |
|
Synopsis: 2 day
introductory course covering databases, tables, the datasheet,
sorting and manipulating tables, import/export, queries,
forms, reports and macros. Using a modern case-based approach,
students will create a small database application during this
course. This database can be tailored to the needs of custom
groups or private training students. No prior knowledge of
Access is assumed. |
|
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
Data |
2.0 Hours |
| |
- Relational database foundations and design
- Creating an MS Access database
- Designing tables
- Field and table validation
- Manipulating and sorting the datasheet
- Office Links
- Creating Permanent Links between Tables
|
|
| Session
2 |
Filters, Queries,
Reports & Forms |
3.0 Hours |
| |
- Filters
- Creating simple and multi-table queries
- Using the expression builder
- Calculated fields and concatenation
- Summary queries
- Using the report and form wizards
- Creating a basic switchboard for your application
|
|
| Session
3 |
Reports and Forms
in Depth |
4.0 Hours |
| |
- Creating reports and subreports.
- Formatting your report.
- Adding calculations to your report
- Adding graphics.
- Creating forms and subforms.
- Unbound forms.
- Using the builders and wizards.
|
|
| Session
4 |
Automating
Microsoft Access Tasks |
3.0 Hours |
| |
- Exporting tables to Excel and text files
- Importing and linking files
- Advanced queries.
- Macros
- Using control wizards.
- Finalizing your switchboard
|
|
|
|
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. |
|
| |
