This module provides an overview of database theory as students gain practical experience with Microsoft Access 2019.
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
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
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