# Microsoft Access Level II (Self-Paced)

Canonical URL: <https://www.creativelive.com/classes/microsoft-access-level-ii-self-paced>

## Overview

If you're already managing databases in Microsoft Access, this self-paced Level II course will take your skills further. Learn how to create relational databases, write advanced queries, and generate sophisticated reports while deepening your understanding of fundamental concepts like relational database structure and data validation.

Building on the basics from Microsoft Access Level I, which covers creating tables, forms, reports, and queries, this course expands your knowledge to include advanced features and techniques. By mastering these skills, you’ll improve your database management efficiency and increase your ability to handle complex tasks, streamlining your workflow and boosting productivity.

## What you'll learn

- Design a relational database and join tables to retrieve data from multiple sources
- Validate data entered into the database to ensure accuracy
- Use advanced queries to manipulate and analyze data
- Organize your database for better performance and data integrity
- Customize reports to format data and create specific print layouts

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

## Pricing

**Tuition:** $325