|
|
AIA101S: Accelerated Introduction to Access Basic
|
Book List |
Course Links
|
|
Tuition: $245.00 per student |
Length: 1 day |
|
Synopsis:
Basic Accelerated Introduction to Microsoft Access course for experienced Microsoft Office users. Same as day 1 of AIA101. Covers tables, external data, queries, forms and reports. Does not include action queries, macros or navigation. 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 a scheduled class 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 | 2.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.
|   |
Materials:
|
Location:
Classes are normally taught on-site at your facilities or at our studio in San Juan Capistrano, Orange County, California. We may also be able to host the class in a rented university classroom near you. Please see FAQs if interested.
|
Related Services |
Need
help with a project? We may also provide programming
and consulting services covering the above material. See
Programming and Consulting for more information.
|
|
|
|