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.

Access Training Class - Intermediate Course Dates

All classes are led by a live instructor. Class times listed are Eastern time.

Course Title	Course Dates	Course Location	Fee	Register
Access Training Class - Intermediate Weekdays Online	Tue, Oct 20 2020 10:00 am to 5:00 pm American Graphics Institute American Graphics Institute https://www.agitraining.com	Online Live instructor-led class online	1969-12-31T19:00:00-05:00 $249.00
Access Training Class - Intermediate Weekdays Online	Thu, Dec 10 2020 10:00 am to 5:00 pm American Graphics Institute American Graphics Institute https://www.agitraining.com	Online Live instructor-led class online	1969-12-31T19:00:00-05:00 $249.00

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.