Disclosure: when you buy through links on our site, we may earn an affiliate commission.

Microsoft Office Access 2016: Part 2 (Intermediate)

Expand your knowledge of relational database design, write advanced queries, validate data and customize reports.
(34 reviews)
469 students
Created by


CourseMarks Score®







Platform: Udemy
Video: 2h 35m
Language: English
Next start: On Demand

Table of contents


Your training and experience using Microsoft Access 2016 has given you basic database management skills, such as creating tables, designing forms and reports, and building queries. In Part 2 (Intermediate) of the course, you will expand your knowledge of relational database design, write advanced queries, structure existing data, validate data entered into a database, and customize reports. Extending your knowledge of Microsoft Access 2016 will result in a robust, functional database for your users.
Table of Contents:
01 Designing a Relational Database
02 Joining Tables
03 Using Data Validation
04 Creating Advanced Queries
05 Organizing a Database for Efficiency
06 Using Advanced Reporting Techniques

You will learn

✓ Design a relational database.
✓ Join tables to retrieve data from unrelated tables.
✓ Validate data entered into a database.
✓ Use advanced queries to manipulate your data.
✓ Organize a database for efficiency and performance, and to maintain data integrity.
✓ Customize reports to organize the displayed information and produce specific print layouts.


• To ensure your success, it is recommended you have completed Microsoft Office Access 2016: Part 1 or possess equivalent knowledge. It is also suggested that you have end-user skills with any current version of Windows, including being able to start programs, switch between programs, locate saved files, close programs, and use a browser to access websites.

This course is for

• If you are wishing to gain intermediate-level skills or individuals whose job responsibilities include constructing relational databases, performing database maintenance, or creating advanced queries and reports, this course is for you.
Training Company
SONIC Performance Support is a leading provider of e-learning and performance support solutions. We proudly serve individuals, government agencies, schools and businesses of all sizes. SONIC Performance Support provides high-quality video training, that is used by well-known domestic and foreign companies. With video based training, you have a personal coach explaining and demonstrating the task at hand. You can stop the video, perform the task in the application, and rewind if you want to review. 
Browse all courses by on Coursemarks.
Platform: Udemy
Video: 2h 35m
Language: English
Next start: On Demand

Students are also interested in