Skip to main content

Business&ITCenter21: Microsoft Access Fundamentals (2019)

This module provides an overview of database theory as students gain practical experience with Microsoft Access 2019.

Start My Curriculum Trial


Unit: Introduction to Microsoft Access

In this unit, students will learn about Microsoft Access basics as they are introduced to databases, tables, records and fields, data integrity and the difference between a database and a database management system. Then they will use Microsoft Access 2019 to open and save databases, use data sheets and form views, and search and update records. 


  1. Microsoft Access Tour 
  2. Getting Started in Microsoft Access 
  3. Quiz


Unit: Database Tables

In this unit students will learn about: creating their own database tables and forms in Access as they use data sheet views, add fields to a form, arrange controls on a form, and understand data types and primary keys. 

  1. Create a Table 
  2. Create a Form 
  3. Quiz


Unit: Queries & Reports

In this unit students will learn about: searching, sorting and filtering database tables in Microsoft Access. They will also learn about table relationships, primary and foreign keys, creating queries between tables, using the Query Wizard, filtering query results, and creating a report based on a query. 

  1. Searching and Filtering 
  2. Relationships and Queries 
  3. Reports 
  4. Quiz

Start My Free Curriculum Trial

Back to Catalog