Access Level 2

Audience:

This course is designed 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.

Prerequisites:

Equivalent Knowledge from MS Access Basic Basic understanding of Windows 7 or Windows 10

Description:

In 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. Extending your knowledge of Microsoft Access will result in a robust, functional database for your users.

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