|
|
|
|
AIN100A: Introduction to MS Access I
|
Course Links |
Practice Test
|
|
|
|
Tuition:
$245.00 per student |
Length: 1 day |
|
|
Synopsis:
1 day introductory Microsoft Access course covering databases, tables, the datasheet, sorting and manipulating tables, basic queries, reports and forms. Using a modern case-based approach, students will create a small database application during this course. No prior knowledge of Access is assumed. (Same as AIN100 Introduction to Microsoft Access day 1; 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 | 2.0 Hours | | |
- Filters
- Creating simple and multi-table queries
- Calculated fields and concatenation
- Summary queries
- Using the expression builder
| | | Session 3 | Basic Reports & Forms | 2.0 Hours | | |
- Creating a report
- Creating a form
- Finding and filtering data
- Adding a 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.
|
|
|
|
