Microsoft Office Access 2016: Part 2 (Intermediate)

Microsoft Office Access 2016: Part 2 (Intermediate)

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

Expand your knowledge of relational database design, write advanced queries, validate data and customize reports.

Url: View Details

What you will learn

• Design a relational database.
• Join tables to retrieve data from unrelated tables.
• Validate data entered into a database.

Rating: 4.3

Level: Intermediate Level

Duration: 2.5 hours

Instructor: SONIC Performance Support - E-Learning Experts