Intermediate

Mastering Access 2016 – Intermediate

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.

Curriculum

20 Sections
2h 50m Duration

Expand All

Relational Database Design

Creating a Table

Creating Table Relationships

Creating Query Joins

Relating Data within a Table

Working with Subdata Sheets

Mastering Access 2016 – Intermediate

Curriculum

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

About Us

TOIT blends technical know-how and a quality knowledge base and implements that blend throughout the four corners of the globe.

Follow Us

Get In Touch

Resources

Categories

© 2025. All Rights Reserved.

Mastering Access 2016 – Intermediate

Curriculum

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

Deleting Course Review

Course Access

Categories

Buy for group

Mastering Access 2016 – Intermediate

You don't have any groups yet

Choose Group(s)