Business&ITCenter21: Access Fundamentals 2021

Phase: Learn & Practice

Unit 1: Introduction to Microsoft Access

In this unit, students will learn about Microsoft Access basics, including 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 with Microsoft Access

Unit 2: Database Tables

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

Lessons:

1. Create Your Own Table
2. Create Your Own Form

Unit 3: Queries and Reports

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

Lessons:

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