Microsoft Access 2019 and 365 Classroom Training Curriculum

Rated 4 out of 5, based on 1 reviews
1 Rating
Grade Levels
8th - 12th, Higher Education, Adult Education, Homeschool, Staff
Formats Included
  • Zip
189 pages
Share this resource
Report this resource to TPT


Designed with the busy teacher in mind, this complete course curriculum in Microsoft Access 2019 and 365 includes everything you need to educate your students and staff. Professionally developed and sold all over the world, these materials are provided in full-color PDF format with not-for-profit reprinting rights and offer clear, concise, and easy-to-use instructions. Perfect for teachers, students, staff, and individuals. Includes:

· Course Syllabus

· Classroom Instruction Manual (189 pages) with Practice Exercises and Keyboard Shortcuts

· 108 Individual Lessons

· Cumulative Review (Test) Questions

· Cumulative Review (Test) Answer Sheet

· Cumulative (Test) Answer Key

· One 2-Page Quick Reference Guide

Topics Covered:

Getting Acquainted with Access
1. Creating a New Database
2. Overview of a Database
3. The Access Interface
4. Touch Mode
5. Viewing Database Objects in the Navigation Bar
6. Opening and Closing Databases

Creating Relational Database Tables
1. The Flat-File Method of Data Storage
2. The Relational Model of Data Storage
3. Tips for Creating a Relational Database
4. Creating Relational Database Tables
5. Assigning a Primary Key to a Table

Using Tables
1. Using Datasheet View
2. Navigating in Datasheet View
3. Adding Records in Database View
4. Editing and Deleting Records in Datasheet View
5. Inserting New Fields
6. Renaming Fields
7. Deleting Fields

Field Properties
1. Setting Field Properties
2. The Field Size Property
3. The Format Property for Date/Time Fields
4. The Format Property for Logical Fields
5. Setting Default Values for Fields
6. Setting Input Masks
7. Setting Up Validation Rules and Responses
8. Requiring Field Input
9. Allowing Zero Length Entries

Joining Tables
1. The Relationships Window
2. Enforcing Referential Integrity
3. Creating Lookup Fields

Indexing Tables
1. Indexes
2. Creating Indexes
3. Deleting Indexes

1. Using the Simple Query Wizard
2. Designing Queries
3. Joining Tables in a Query
4. Adding Criteria to the QBE Grid
5. Running a Query
6. SQL View
7. Sorting Query Results
8. Hiding Fields in a Result Set
9. Using Comparison Operators
10. Using AND and OR Conditions

Advanced Queries
1. Using the Between… And Condition
2. Using Wildcard Characters in Queries
3. Creating a Calculated Field
4. Creating Top Value Queries
5. Aggregate Function Queries
6. Parameter Queries

Advanced Query Types
1. Make Table Queries
2. Update Queries
3. Append Queries
4. Delete Queries
5. Crosstab Queries
6. The Find Duplicates Query
7. Removing Duplicate Records from a Table
8. The Find Unmatched Query

Creating Forms
1. Forms Overview
2. The Form Wizard
3. Creating Forms
4. Using Forms
5. Form and Report Layout View
6. Form and Report Design View
7. Viewing the Ruler and Grid
8. The Snap to Grid Feature
9. Creating a Form in Design View
10. Modifying Form Sections in Design View

Form & Report Controls
1. Selecting Controls
2. Deleting Controls
3. Moving and Resizing Controls
4. Sizing Controls to Fit
5. Nudging Controls
6. Aligning, Spacing, and Sizing Controls
7. Formatting Controls
8. Viewing Control Properties

Using Controls
1. The Controls List
2. Adding Label Controls
3. Adding Logos and Image Controls
4. Adding Line and Rectangle Controls
5. Adding Combo Box Controls
6. Adding List Box Controls
7. Setting Tab Order

1. Creating Subforms
2. Using the Subform or Subreport Control

1. Using the Report Wizard
2. Creating Basic Reports
3. Creating a Report in Design View
4. Sorting and Grouping Data in Reports
5. Creating Calculated Fields

1. Creating Subreports

Charting Data
1. Using Charts
2. Insert a Modern Chart

1. Creating a Standalone Macro
2. Assigning Macros to a Command Button
3. Assigning Macros to Events
4. Using Program Flow with Macros
5. Creating Autoexec Macros
6. Creating Data Macros
7. Editing Named Data Macros
8. Renaming and Deleting Named Data Macros

Switchboard and Navigation Forms
1. Creating a Switchboard Form
2. Creating a Navigation Form
3. Controlling Startup Behavior

Advanced Features
1. Getting External Data
2. Exporting Data
3. Setting a Database Password

Helping Yourself
1. Using Access Help
2. The Tell Me Bar

Total Pages
189 pages
Answer Key
Teaching Duration
Report this resource to TPT
Reported resources will be reviewed by our team. Report this resource to let us know if this resource violates TPT’s content guidelines.


Questions & Answers


TPT empowers educators to teach at their best.

More About Us

Keep in Touch!

Sign Up