Computer and Business Skills training

Sign Up
Home / Access / Level 1

Microsoft Access Training Course Level 1

Course Description

This hands-on beginners course is suitable for Access 2010/2013/2016 users.

Live face-to-face instructor-led training. No minimum class size - all classes guaranteed to run.

You will learn the skills necessary to create a new database, construct data tables, design basic forms and reports, run queries and secure your data.

View our full range of Microsoft Access training courses, or see below for the detailed outline for Access Level 1.

1 Day | $350.00

Register button

Detailed course outline

  • Opening and Closing Access
    • Opening Access
    • Using the Recent List and Opening Files
    • Understanding Security Warnings
    • Understanding the Ribbon and the Status Bar
    • About Your Account
    • Closing Files vs. Closing Access
  • An Introduction to Databases
    • About Common Database Terms
    • Using the Navigation Pane
    • Understanding Tables and Table Relationships
    • Understanding Queries
    • Understanding Forms
    • Understanding Reports
    • Closing Database Objects
  • An Introduction to Desktop Databases
    • Opening a Table in Data Sheet View
    • About Keys
    • About Data Types
    • Entering and Editing Data
    • Selecting Records
    • Deleting Records
    • About Fields
  • Understanding Basic Table Tasks
    • Entering a New Record
    • Saving Records
    • Using the Clipboard
    • Formatting Text
    • Adding a Field by Entering Data
  • Working With Fields
    • Adding a Specific Type of Field
    • Changing Field Name, Caption, or Description
    • Changing the Data Type
    • Changing Field Format
    • Deleting a Field
  • Navigating Records
    • Filtering Records
    • Sorting Records
    • Searching for Records Using the Search Box
    • Finding and Replacing Text
    • Navigating Records
  • An Introduction to Queries, Forms, and Reports
    • Types of Queries
    • Creating a Query with the Wizard
    • Executing a Query
    • About the Different Form Views
    • Viewing a Report
    • Using Print Preview
  • Protecting Your Data
    • Planning Backups
    • Backing Up a Database
    • Restoring a Database
    • Restoring Objects in a Database

Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class.



230 W Monroe St
IL 60606View Map

Guaranteed to Run Limited Seats Left

Class times: 9.00am to 4.30pm

Servicing Arlington Heights, Aurora, Bollingbrook, Chicago Loop,
Deerfield, Des Plaines, Evanston, Highland Park, Joliet, Naperville,
Schaumburg, Skokie, South Chicago and surrounding areas.

Other Cities

Request onsite training quote

Los Angeles

915 Wilshire Blvd
Los Angeles
CA 90017View Map

Guaranteed to Run Limited Seats Left

Class times: 9.00am to 4.30pm

Servicing Anaheim, Burbank, Covina, Downtown, Fullerton,
Irvine, Long Beach, Northridge, Pasadena, San Bernardino,
Santa Monica, Van Nuys, Ventura and surrounding areas.

Related courses

Why train with us?Need Group training quotation?Fresh Peet's Coffee brewed every dayBook two levels of Access training and save $100 FREE Class Repeat with each courseBook 3 Level of Access Training and save $150