
All Microsoft Access classes include
Free retakes
Detailed curriculum
Live instructor
Flexible rescheduling
Certificate of Completion
Access Training Class - Intermediate
Access Training Class - Intermediate
Take your Access skills to the next level and improve your efficiency with Access and relational databases in this intermediate Microsoft Access course. Learn to design better relational databases, join tables, improve data structure, validate data, conduct advanced queries, organize data and create more advanced reports. Participants will work with their own relational database that they will create as part of the course.
Questions about this intermediate Microsoft Access class? Interested in a private or customized training? Call to speak with a training consultant: 781-376-6044.
This course is available individually or as part of these certificate programs:
Please call 800-851-9237 or 781-376-6044 to schedule a course.
Access Training Course - Intermediate: Complete Class Topics
Designing Relational Databases
- Fundamentals of Relational Database Design
- Creating Tables
- Creating Table Relationships
Joining Tables in Access
- Creating Query Joins
- Relating Data Within a Table
- Working with Subdata sheets
Using Access Data Validation
- Validating Fields
- Using options for Form and Record Validation
Creating Advanced Queries in Access
- Creating Parameter Queries
- Summarizing Data
- Creating Subqueries
- Creating Action Queries
- Creating Unmatched and Duplicate Queries
Organizing an Access Database for Efficiency
- Data Normalization
- Create Junction Tables
- Improving Table Structure
Using Advanced Reporting Techniques in Access
- Including Control Formatting in Reports
- Adding Calculated Fields to Reports
- Add a Subreport to Existing Reports
We recommend that you have Microsoft Access installed on your computer before starting this class.
You will receive a comprehensive course manual for this Intermediate Access class developed by the instructors at AGI. AGI instructors have created many of the official training guides and books for Microsoft.