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