This module provides an overview of database theory as students gain practical experience with Microsoft Access.
Unit: Introduction to Microsoft Access
Description
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 to open and save databases, use data sheets and form views, and search and update records.
Lessons
1. Microsoft Access Tour
2. Getting Started in Microsoft Access
3. Quiz
Unit: Database Tables
Description
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.
Lessons
1. Create a Table
2. Create a Form
3. Quiz
Unit: Queries & Reports
Description
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.
Lessons
1. Searching and Filtering
2. Relationships and Queries
3. Reports
4. Quiz
