What is a database?

Differences between Excel and Access

Opening and navigating Access

Understanding tables, queries, forms, and reports

Creating a new table

Setting field names, data types, and primary keys

Entering, editing, and deleting data

Understanding field properties (e.g., validation, default values)

Introduction to relational databases

Creating one-to-many relationships

Enforcing referential integrity

Using the Relationships window

Creating Select queries

Filtering and sorting records

Using criteria expressions

Running queries with multiple tables (joins)

Creating a simple form with Form Wizard

Adding, editing, and deleting records

Modifying layout and design

Using form controls (drop-downs, checkboxes, etc.)

Creating reports using the Report Wizard

Grouping and sorting data

Adding headers, footers, and logos

Formatting reports for printing

Using parameter queries

Creating calculated fields in queries

Using wildcards and functions

Action queries: Make-table, Append, Update, and Delete

Importing from Excel or CSV

Exporting reports or queries to PDF or Excel

Linking external data sources

Refreshing linked data

Creating subforms

Embedding charts and visuals

Automating navigation with buttons

Building a simple dashboard interface

Building a small working database (contacts, inventory, or student records)

Applying design and formatting best practices

Reviewing and troubleshooting

Preparing for further learning (e.g., Access Intermediate or SQL)

Post-Test