Pre-written, Customizable, print-on-demand Training Materials that you can re-brand!
Instructor-Led Training Materials

Microsoft Access 365

Courseware you can customize. Everything you need to teach Microsoft Access 365

Unlimited Users

Unlimited Printing Rights

Completely Customizable

Want to see a Preview? FREE DOWNLOAD
The Ultimate Trainers Toolkit $495USD  Buy

Microsoft Access 365: Part 1

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.


Why Velsoft Courseware?

Microsoft Access 365: Part 1 is one-day course that provides your students with a comprehensive overview of the knowledge and skills need to ensure the viability of businesses in today's world. The course material applies equally to product and service-based enterprises.

custom-icon

Fully Customizable

Tailor courses to suit the needs of your business, such as adding your company name and logo, or your own pictures.

reprint-icon

Unlimited Printing Rights

Print as many copies as you want, anywhere at any time.

cost-icon

No Annual Renewal Cost

Your purchase gives you a perpetual license for your business.

oneoff-icon

One-off Pricing

We offer a one-time payment model with a lifetime license.

HAVE A LOOK INSIDE

Microsoft Access 365: Part 1



mos5041

Here's what you receive with this Microsoft Access 365: Part 1 courseware title

What's in the box

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.
Exercise Workbook
Whether or not you choose to introduce exercises into your training is up to you as the facilitator. In case you want to do this Velsoft offers you an Exercise Workbook (also customizable) that is specific to the course you are offering.
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 the PowerPoint versions of all the courses, prepared for you in advanced.
Quick Reference Guide
Quick Reference Guides are a favorite tool for trainers to provide to their learners. Each Quest Reference Guide summarizes the most important elements in each courseware title down to two pages.

Course Outline

Outline for Microsoft Access 365: Part 1

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

Summary

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

Summary

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

Summary

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

Summary

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

Summary

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

Summary

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

Summary

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

Summary

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

Appendices

Keyboard Shortcut Quick Reference Sheet

Glossary

All the hard parts of courseware, solved.

Save Time and Money with Courseware. The idea behind courseware is simple, we’ve written courses for you. You can edit them; you can modify them you can even rebrand them as your own. We’ve done the hard work of researching and developing the content taking careful attention to the quality and relevance of each courseware title we offer you. Each course is tested in the classroom and proven to be effective in any training or workshop environment. Plus, you have the unlimited rights to make any changes you want to the content in order to fit your training requirements and organizational needs.

TRUSTED BY
trusted-logos trusted-logos trusted-logos trusted-logos trusted-logos trusted-logos trusted-logos trusted-logos trusted-logos trusted-logos trusted-logos
SEE MORE
SCORM COMPLIANT

Available as an eLearning Course

SCORM Compliant eLearning Course

Microsoft Access 365

eLearning version of this course for use in your LMS. Includes ability to customize the course for specific training needs.

TRY A SAMPLE SAMPLE
12 MONTH LICENSE $495USD  Buy
mos5041_el.png

TESTIMONIALS

Hey there! I'm Michael.

How can I help you?

I don't have an LMS yet. Is there still a way to use your courses?

Good news! We have an LMS and would be happy to provide you with free access to this.

questions-guy.png
WE'RE HERE TO HELP
Chief Happiness Officer

Every Velsoft interaction is backed by real people with industry expertise dedicated to answering your questions and helping your business grow. We're here for you, talk to us!

ASK A QUESTION
courseware-flyer.png

COURSEWARE SAMPLE

Courseware you can customize.

x

View an eLearning Course

Begin

Download a SCORM sample to try in your LMS

Download

View an eLearning Course

SCORM COMPLIANT

Available as an eLearning Course

x
elearning_sample_image.jpg

ELEARNING SAMPLE

eLearning you can customize.

x

COURSEWARE SAMPLE

Courseware you can customize.

x
policy.png

Safe & Inclusive Workplace

By Velsoft

x
ilt-courses.png

Seeing Double

August Only

x
velsoft_logo.png
x
emily.png
mos5041_up.png

COURSEWARE SAMPLE

Courseware you can customize.

x