When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.
Microsoft Office Access 2016: Part 2 (Intermediate)
Expand your knowledge of relational database design, write advanced queries, validate data and customize reports.
This Course Includes
udemy
4.1 (36 reviews )
2h 35m 
english
Online - Self Paced
professional certificate
Udemy
About 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
What 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..