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.
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
Who 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.
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.