|
|
|
|
|
|
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. 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 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 | 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 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.
|
|
|
|
