Become a Member   |   Contact Us   |   Marketplace   |   Sign In
Microsoft Access 2016 Intermediate Online Training Series

Training Series Overview

This course will teach students how to design a relational database, join tables, use data validation, create advanced queries, organize a database for efficiency, and use advanced reporting techniques.

Career Path: In high-growth industries, entry-level employees who hold a Microsoft Office Specialist (MOS) certification can earn up to $16,000 more, annually, than their peers. Five times as many high-growth/high-salary positions require experience with Office than all non- Microsoft software skills combined. Twenty-nine percent of tomorrow’s high-growth/high-wage positions require Office or Office- related skills.

Series Taught By: Patrick Loner

Certification Details

Successful candidates for the Microsoft Office Specialist Access 2016 certification exam will have a fundamental understanding of the Access environment and the ability to complete tasks independently. They will know and demonstrate the correct application of the principle features of Access 2016. Candidates will learn how to design a relational database, join tables, use data validation, create advanced queries, organize a database for efficiency, and use advanced reporting techniques.

Certification Exam Details:
This training will prepare you for the Microsoft Office Specialist Certification. To learn more, please go to Click here for certification details.

Available CEUs for Course Series Completion: 5
Students can earn up to 5 CEUs for fully completing this course series. This information will be displayed on the certificate of completion. Learn More

Access Training Courses Below

Click any of the titles below to launch your videos:


Course 01 - Designing a Relational DatabaseAccess Now - No Membership Required 34m

Course 02 - Joining Tables 23m

Course 03 - Using Data Validation 30m

Course 04 - Creating Advanced Queries 37m

Course 05 - Organizing a Database for Efficiency 19m

Course 06 - Using Advanced Reporting Techniques 17m

Training Final Exam

Are you ready to earn your certificate of completion? If so, Launch the Final Exam below to do so now!

Training Final Exam

Legal