# Microsoft Access Level I

Canonical URL: <https://www.careercenters.com/courses/access-level-I>

## Overview

### Microsoft Access Training in Manhattan

Learn the basics of relational database management in Microsoft Access Level I. Do you manage massive datasets in multiple Excel workbooks? If so, you can likely benefit from using Microsoft Access. With MS Access, you can enter, organize, and create reports on massive datasets much more quickly than Excel.

Designed as a relational database solution by Microsoft, you can manage personal data or use it as an enterprise solution to manage data for an entire organization. In this introductory course for Microsoft Access 2016, you will learn how to create new databases, build tables, design forms, generate reports, and much more. By the end of Microsoft Acess Level I, you'll be able to join, filter, and sort data in Microsoft Access.

### Enroll in the Microsoft Access Bootcamp 

Enroll in the [Microsoft Access Bootcamp](/courses/microsoft-access-bootcamp), which includes Microsoft Access Level I and [Microsoft Access Level II](/courses/access-level-ii). On Day 1, you'll learn the basics of Microsoft Access, including creating tables and simple forms. On Day 2, you'll explore intermediate features such as advanced data controls and sharing data with other applications. The MS Access Bootcamp is ideal for complete beginners, self-taught users with knowledge gaps, and experienced MS Access users who need a refresher.

### Earn Microsoft Access Certification 

Prove your knowledge of Microsoft Access by earning a certification. Our [Access Specialist Certification Program](/courses/access-specialist-certification-bundle) will prepare you for the official  MOS (Microsoft Office Specialist) Access certification exam. The certification package includes a free course retake, two hours of private tutoring with the instructor, and the certification exam fee.

### Free Retake

Retake Microsoft Access Level I within 1 year of your enrollment free of charge.

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

## Pricing

**Tuition:** $325