Access Level 2

In this course, you will create and manage an Access 2016 database.
You will:

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

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

Appendix A: Microsoft Office Access 2016 Exam 77-730
Appendix B: Microsoft Access 2016 Common Keyboard Shortcuts