Microsoft 365 Access Training

Microsoft 365 - Access Level 1

Overview

This 1-day, hands-on course is based on the current Microsoft 365 Access application. Participants using Access 2016 or later will be able to follow along, although some of the newest features may not be available in older versions.

This course is designed for learners with no previous or with minimal experience using Access or databases. Intermediate and self-taught users may find this course a valuable refresher.

Microsoft Access is a powerful relational database application that enables users to store, organize, and analyze data efficiently. This course introduces participants to the fundamentals of database design and progresses through advanced techniques for creating queries, forms, reports, and automation tools. Learners will gain practical skills to build and manage databases, integrate Access with other Microsoft applications, and apply best practices for data integrity and security. By the end of the series, participants will be equipped to use Access confidently for real-world business and data management tasks.

Prerequisites

Solid experience with Windows computing
Familiarity with databases is beneficial

Learning Objectives

Through the use of hands-on exercises participants will learn to:

Create and manage Access databases.
Understand how tables work in a relational database.
Design basic queries.
Understand data integrity principles.
Apply best practices for relational design.
Create basic forms and reports.

Course Outline

Module 1 - Introduction to Access

What is a database? Key concepts

Access interface and navigation

Module 2 - Creating Tables

Data types and field properties

Primary keys and indexing

Module 3 - Basic Queries

Select queries

Sorting and filtering data

Module 4 - Forms and Reports

Simple form creation

Basic report generation

ON-TRACK Corporate Training has a diverse and flexible schedule that can be customized to your needs. We offer group courses (both public and corporate), one-on-one training, virtual (on-line) classroom (Zoom etc.) and on-site training options. We also have easily accessible on-line training videos on OnTrackTV.