# Microsoft Access Level II

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

## Overview

Are you currently managing databases in Microsoft Access? Learn how to create relational databases and generate advanced reports in Microsoft Access Level II. In this course, you'll learn some advanced features in Access and improve your understanding of fundamental concepts like queries and relational database structure.

Microsoft Access Level I teaches basic tasks such as creating tables, forms, reports, and queries. Microsoft Access Level II builds on this training by exploring how to create a relational database, code advanced queries, and perform data validation. By expanding your expertise in Microsoft Access, you'll have solid database management skills to increase database functionality and accelerate your workflow on the job.

## 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 — NYC
- Oct 22, 2026 10:00am–5:00pm — NYC

## Instructors

### Garfield Stinvil — Senior Instructor

Garfield is an experienced software trainer with over 16 years of real-world professional experience. He started as a data analyst with a Wall Street real estate investment company & continued working in the professional development department at New York Road Runners Organization before working at Noble. He enjoys bringing humor to whatever he teaches and loves conveying ideas in novel ways that help others learn more efficiently.

Since starting his professional training career in 2016, he has worked with several corporate clients including Adobe, HBO, Amazon, Yelp, Mitsubishi, WeWork, Michael Kors, Christian Dior, and Hermès. 

Outside of work, his hobbies include rescuing & archiving at-risk artistic online media using his database management skills.

## Pricing

**Tuition:** $325