Fully Customizable Courseware For Trainers
Microsoft 365 Access: Part 1
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
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
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.
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 SAMPLE
Courseware you can customize.
View an eLearning Course
SCORM COMPLIANT
Available as an eLearning Course
ELEARNING SAMPLE
eLearning you can customize.
COURSEWARE SAMPLE
Courseware you can customize.
Safe & Inclusive Workplace
By Velsoft
Seeing Double
August Only
COURSEWARE SAMPLE
Courseware you can customize.