AIA101: Accelerated Introduction to Access
Accelerated Introduction to Microsoft Access, the powerful but user-friendly desktop database. For experienced Microsoft Office users. Corresponds roughly to material required for MOS certification. Covers tables, external data, queries, forms, reports, action queries, macros and 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.
Corporate groups (min. 2 students) at your facility or online.
Flexible. Group and private training can be scheduled to suit your needs. See calendar for scheduled classes.
2-4 students 20%, 5-8 30%, >8 quote
Session 1
- 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
- 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.
Session 3
- Action queries.
- Macros
- Using control wizards.
- Switchboards & Navigation Forms