Microsoft® Access® 2016: Level 2

Duration:

1 Day (6.5 instructional hours)

Access 2016

Course Number: 091046S

Course Objective:

Upon successful completion of this 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.

Target Student:

This course is intended for students wishing to gain intermediate-level skills or individuals whose job responsibilities include constructing relational databases, performing database maintenance, or creating advanced queries and reports.

Course Objective:

To ensure success, students will need to be familiar with using or have equivalent knowledge of: Microsoft Access 2016: Part 1.

Course Outline

Lesson 1: Designing a Relational Database

Topic A: Relational Database Design
Topic B: Create a Table
Topic C: Create Table Relationships

Lesson 2: Joining Tables

Topic A: Create Query Joins
Topic B: Relate Data Within a Table
Topic C: Work with Subdatasheets

Lesson 3: Using Data Validation

Topic A: Use Field Validation
Topic B: Use Form and Record Validation

Lesson 4: Creating Advanced Queries

Topic A: Create Parameter Queries
Topic B: Summarize Data
Topic C: Create Subqueries
Topic D: Create Action Queries
Topic E: Create Unmatched and Duplicate Queries

Lesson 5: Organizing a Database for Efficiency

Topic A: Data Normalization
Topic B: Create a Junction Table
Topic C: Improve Table Structure

Lesson 6: Using Advanced Reporting Techniques

Topic A: Include Control Formatting in a Report
Topic B: Add a Calculated Field to a Report
Topic C: Add a Subreport to an Existing Report