# Microsoft Access Level II

Canonical URL: <https://www.creativelive.com/classes/access-level-2>

## Overview

Build on your Microsoft Access foundation and learn how to create relational databases and generate advanced reports. This course deepens your understanding of core concepts such as queries and relational database structure.

While Access Level I covers essential tasks such as creating tables, forms, reports, and queries, Level II expands on that training by exploring how to create a relational database, write advanced queries, and perform data validation. By strengthening your Access expertise, you'll gain solid database management skills that increase functionality and accelerate your workflow.

## What you'll learn

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

## Prerequisites

Students must have Access proficiency equivalent to our [Microsoft Access Level I](/classes/access-level-1) course.

## Curriculum

#### Designing a Relational Database

- Relational Database Design
- Create a Table
- Create Table Relationships

#### Joining Tables

- Create Query Joins
- Relate Data Within a Table
- Work with Subdatasheets

#### Using Data Validation

- Use Field Validation
- Use Form and Record Validation

#### Creating Advanced Queries

- Create Parameter Queries
- Summarize Data
- Create Subqueries
- Create Action Queries
- Create Unmatched and Duplicate Queries

#### Organizing a Database for Efficiency

- Data Normalization
- Create a Junction Table
- Improve Table Structure

#### Using Advanced Reporting Techniques

- Include Control Formatting in a Report
- Add a Calculated Field to a Report
- Add a Subreport to an Existing Report

## Schedule
- Jul 31, 2026 10:00am–5:00pm — Live Online
- Oct 22, 2026 10:00am–5:00pm — Live Online

## Pricing

**Tuition:** $325