Fully Customizable Courseware For Trainers

Microsoft 365 Access: Part 1

Easily edit and rebrand as your own


Buy Now DEMO
Download a Free Sample DOWNLOAD
Materials for
hours of
Easily edited

Easily edit and rebrand as your own

Our mission is to provide you with the best possible courseware so you can teach incredible classes and workshops

High quality course content - written for you

Save hundreds of hours in developing training materials. Download our proven content used by trainers in 164 countries worldwide.

Enjoy confidence in the classroom

Facilitate perfect workshops everytime with high-quality training material with all the training components you need.

Save time & money with pre-written materials

Focus your attention on the training and we'll take care of the materials.

Course description+

Microsoft Access 365 is Microsoft’s flagship database application that allows you to create and manage databases. In this version of Access you will find a few new features that help you to better visualize data, and provide support for new datatypes. As well, interface and workflow improvements have been incorporated.

This course will help novice computer users quickly learn the basics of using Microsoft Access 365. Upon completion of this course, users should be comfortable navigating the Microsoft Access interface, creating a new database, querying a database, generating reports, sharing data, and more.

For more information, download a free sample now.

Course outline+

About This Course

Course Prerequisites

Course Overview

Course Objectives

How to Use This Book

Lesson 1: Getting Started with Access

TOPIC A: What is Microsoft Access?

About Microsoft Access

What’s New in Microsoft Access?

Navigating the Microsoft Access Interface

Working with Microsoft Access Files

Using the Tell Me Box

Access Advanced Help

Activity 1-1: Getting Help in Access

TOPIC B: Components of a Database

What are Tables?

What are Fields?

What are Records?

What are Forms and Views?

What are Queries?

What are Reports?

Activity 1-2: Navigating Database Components

TOPIC C: Create a Simple Database

Database Templates

Working with Tables

Object Naming Conventions

Saving a Database

Activity 1-3: Creating a Simple Access Database

TOPIC D: Creating a Simple Form

Ways to Create a Form

Using the Three Form Views

About Form Sections

Saving a Form

Deleting a Form

Activity 1-4: Creating a Simple Form


Review Questions

Lesson 2: Working with Table Data

TOPIC A: Work with Table Data

Using AutoCorrect

Commit, Save, and Undo

Running a Quick Search

Using Find and Replace

Using Datasheet Totals

Activity 2-1: Modifying Table Data

TOPIC B: Work with Records

Adding New Records

Navigating Records

Updating Records Using a Query

Using Append Queries

Activity 2-2: Working with Records

TOPIC C: Sort and Filter Records

Sorting Records

Filtering Records

Other Filter Options

Grouping Records

Activity 2-3: Sorting and Filtering Records

TOPIC D: Create Lookups and Relationships

Using Lookup Fields

Table Relationships

Using the Relationship View

Using the Property Sheet Pane

Activity 2-4: Creating lookups


Review Questions

Lesson 3: Query a Database

TOPIC A: Use a Query to View Data from Multiple Tables

What are the Types of Queries?

Using the Simple Query Wizard

Using Query Views

Run a Query

Use Design View

Saving a Query

Deleting a Query

Renaming a Query

Activity 3-1: Creating a Query

TOPIC B: Sort and Filter Data in a Query

Choosing Query Criteria

Using Comparison Operators

Using Logical Operators

Sorting Query Results

Grouping Query Results

Formatting Query Fields

The Zoom Dialog Box

Activity 3-2: Sorting and Filtering Data in a Query

TOPIC C: Perform Calculations in a Query

The Arithmetic Operators

How to Add Calculated Fields

How to Add Conditional Logic

Activity 3-3: Performing Calculations in a Query


Review Questions

Lesson 4: Create Advanced Queries

TOPIC A: Create Parameter Queries

What are Parameter Queries?

Using the Ampersand Operator

Using Wildcards in Parameter Queries

Activity 4-1: Creating Parameter Queries

TOPIC B: Create Action Queries

What are Action Queries

About the Types of Action Queries

Activity 4-2: Creating Action Queries

TOPIC C: Create Find Duplicate and Find Unmatched Queries

What are Find Duplicate and Find Unmatched Queries?

Using the Find Duplicates Query Wizard

Using the Find Unmatched Query Wizard

Activity 4-3: Creating a Find Duplicates Query

TOPIC D: Summarize Data

What are Crosstab Queries?

Using Crosstab Queries

What are Multiple Table Queries?

Activity 4-4: Summarizing Data


Review Questions

Lesson 5: Generate Reports

TOPIC A: Create a Report

Report Creation Tools

Using the Report Wizard

Using Report Views

Saving a Report

Deleting a Report

Activity 5-1: Creating a Report

TOPIC B: Add Controls to a Report

What are Report Sections?

Adding Controls

Modifying Control Properties

Adding Images

Adding Charts

Activity 5-2: Adding Controls to a Report

TOPIC C: Advanced Reporting

Format Reports

Add Calculated Fields

Add a Subreport to an Existing Report

Adding a Header/Footer

Organize Report Information

Publish a Report as a PDF

Activity 5-3: Organizing Report Information


Review Questions

Lesson 6: Design a Relational Database

TOPIC A: Relational Database Design

What are Relational Databases?

Using the Relational Database Design Process

What are Primary Keys, Foreign Keys, and Composite Keys?

What are Table Relationships?

Activity 6-1: Designing and Creating a Relational Database

TOPIC B: Working with Tables

Creating a New Table

How to Insert Fields

How to Set Data Types

About the Table Properties Dialog Box

Activity 6-2: Creating a Table

TOPIC C: Modify a Table and Fields

Renaming Tables

Changing Field Captions

Changing Field Sizes

Deleting Fields

Configuring Fields to Auto-Increment

Setting the Default Value for a Field

Activity 6-3: Modifying a table and Fields

TOPIC D: Create Table Relationships

Using the Relationships View

About Join Lines

About Referential Integrity

Using the Edit Relationships Dialog Box

Creating a Relationship Report

Activity 6-4: Creating Table Relationships


Review Questions

Lesson 7: Joining Tables

TOPIC A: Create Query Joins

What are Joins?

Creating an Inner Join

Creating an Outer Join

Self-joins and the Table Alias Property

The Join Properties Dialog Box

Activity 7-1: Creating Query Joins

TOPIC B: Working with Subdatasheets and Subqueries

About Subdatasheets

About Subqueries

Activity 7-2: Working with Subdatasheets


Review Questions

Lesson 8: Importing and Exporting Data

TOPIC A: Import Data into Access

Types of Data Imports

Using the Get External Data Wizard

About Delimiters

Activity 8-1: Importing Data into Access

TOPIC B: Export Data

Export Access Data

Export Data to Excel

Activity 8-2: Exporting Data to Excel

TOPIC C: Create a Mail Merge

What is the Microsoft Word Mail Merge Wizard?

Merge Fields

About the Mail Merge Task Pane

Activity 8-3: Creating a Mail Merge


Review Questions

Lesson Labs

Lesson 1

Lesson Lab 1-1

Lesson 2

Lesson Lab 2-1

Lesson 3

Lesson Lab 3-1

Lesson 4

Lesson Lab 4-1

Lesson Lab 4-2

Lesson 5

Lesson Lab 5-1

Lesson 6

Lesson Lab 6-1

Lesson Lab 6-2

Lesson 7

Lesson Lab 7-1

Lesson Lab 7-2

Lesson 8

Lesson Lab 8-1

Course Wrap-Up

Post-Course Assessment

Course Summary

Next Steps


Keyboard Shortcut Quick Reference Sheet


What you get+

Instructor Guide

Velsoft Instructor Guides are the core of each training course. Our Instructor Guides lay out the training in simple, easy-to-follow instructions. You can also customize the Instructor Guides in order to personalize your training.

Student Manual

Each Instructor Guide - for each course - is paired with a Student Manual that you can present to your participants. This customizable Student Manual gives each participant the student version of the course you will be teaching.

Sample Files

Each Velsoft courseware title comes with a Lab Workbook loaded with activities and exercises to practice and reinforce the learners' understanding of the course objectives. Pre-made Sample Exercise Files are provided for use with the Lab Workbook so that you, as the trainer, do not have to prepare activity working files.

Powerpoint Deck

Courseware from Velsoft is designed to give you everything you need for use in the classroom or workshop. This includes PowerPoint slides for classroom use, prepared for you in advance.

Quick Reference Guide

Quick Reference Guides are a favorite tool for trainers to provide to their learners. Each Quick Reference Guide summarizes in two pages the most important elements in each courseware title.

The best courseware in the world has Velsoft on the cover.

Our goal is to improve the daily life of those who train the world.

Velsoft empowers training providers with course material and educational technologies that get results.


Instant download access
Buy Now
Fully customizable

Easily make any changes to the material you like. Simply open in MS Word or Google Docs and localize the content to meet your training needs.

Unlimited reprinting

Print only what you need, when you need it. Print as many copies at your location as you like - forever. This includes editing and printing.

Unlimited users

Train as many people at your location as you like - forever. There is no per-user pricing or limit on the number of people that can be trained.

No annual renewal fees

This course comes with a perpetual license which means once you purchase it you never have to pay anything ever again.



Courseware you can customize.


View an eLearning Course


Download a SCORM sample to try in your LMS


View an eLearning Course


Available as an eLearning Course



eLearning you can customize.



Courseware you can customize.


Safe & Inclusive Workplace

By Velsoft


Seeing Double

August Only



Courseware you can customize.