|
|
|
|
|
|
|
|
|
Tuition: $345.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. Available in Access 2003 and 2007.
|
|
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 for $540.
|
|
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 35%, >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. |
|
| |
