Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
2 Hour(s) 35 Minute(s)
Language
English
Taught by
SONIC Performance Support - E-Learning Experts
Certificate
- Available
- *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Rating
1 views
Course Overview
Expand your knowledge of relational database design, write advanced queries, validate data and customize reports.
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
Course Content
- 6 section(s)
- 40 lecture(s)
- Section 1 Designing a Relational Database
- Section 2 Joining Tables
- Section 3 Using Data Validation
- Section 4 Creating Advanced Queries
- Section 5 Organizing a Database for Efficiency
- Section 6 Using Advanced Reporting Techniques
What You’ll 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.
Skills covered in this course
Reviews
-
TTim Tyndall
Very well presented. I learned some new stuff and feel ready to do the 3rd lesson.
-
DDonna Waterman
I am an advanced user, but found the review helpful. The choppy delivery style was a bit distracting.
-
EEdward Quiles
El profesor es muy pausado , se presenta muy mecanizado , debe fluir más elocuente al hablar
-
JJulia Slabbert
I really enjoyed the course, and found the explanations easy to follow.
