Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Microsoft Access Level II

via Graduate School USA

Go to class Write review

Overview

Advance your database management skills by working with advanced queries, forms, and reports. You’ll explore relational database design, table relationships, and data validation techniques to streamline and analyze data more effectively. This course builds on foundational Access knowledge to help you manage complex data sets with confidence.

Syllabus

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

Taught by

Linda Haynes-Jackson, Clarissa J. Corbin, and Brian Simms

Reviews

Start your review of Microsoft Access Level II