# Microsoft Access Level I

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

## Overview

Learn the basics of relational database management in this introductory Microsoft Access course. If you currently manage large datasets across multiple Excel workbooks, Microsoft Access can help you enter, organize, and generate reports on that data far more efficiently.

Designed as a relational database solution, Access can be used for personal data management or as an enterprise solution for an entire organization. In this course, you'll learn how to create new databases, build tables, design forms, generate reports, and more. By the end of the course, you'll be able to join, filter, and sort data in Microsoft Access.

## What you'll learn

- Navigate within the Microsoft Access application environment, create a simple database, and customize Access configuration options
- Organize and manage data stored within Access tables
- Use queries to join, sort, and filter data from different tables
- Use forms to make it easier to view, access, and input data
- Create and format custom reports

## Curriculum

#### Getting Started with Access

- Orientation to Microsoft Access
- Create a Simple Access Database
- Get Help and Configure Options in Microsoft Access

#### Working with Table Data

- Modify Table Data
- Sort and Filter Records

#### Querying a Database

- Create Basic Queries
- Sort and Filter Data in a Query
- Perform Calculations in a Query

#### Using Forms

- Create Basic Access Forms
- Work with Data on Access Forms

#### Generating Reports

- Create a Report
- Add Controls to a Report
- Enhance the Appearance of a Report
- Prepare a Report for Print
- Organize Report Information
- Format Reports

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

## Pricing

**Tuition:** $325