Mastering Access 2016 – Intermediate
- 20 Sections
- 2h 50m Duration
Relational Database Design
Creating a Table
Creating Table Relationships
Creating Query Joins
Relating Data within a Table
Working with Subdata Sheets
Using Field Validation, Part 1
Using Field Validation, Part 2
Using Forms and Record Validation
Creating Parameter Queries
Summarizing Data
Creating Subqueries
Creating Action Queries
Creating Unmatched and Duplicate Queries
Data Normalization
Creating a Junction Table
Creating a Table Structure
Including Control Formatting in a Report
Adding Calculated Fields to a Report
Adding a Sub-report to an Existing Report
Create custom databases with this modern data-crunching powerhouse!
Microsoft Access lets ordinary users develop powerful databases customized for their business needs.
Building a simple database is one thing, but designing it for optimum performance and data integrity is much more difficult. In this course, experienced Microsoft Access trainer Kathy Jones will build upon the fundamentals of tables, queries, forms, and reports covered in the Basics course. Starting with the essentials of relational database design, this course will expand your knowledge of Microsoft Access by covering topics such as table relationships, query joins, sub datasheets, field validation, parameter queries, and more. You’ll also learn to customize your reports to retrieve exactly the data you need in the format you need it.