As a class or individually work through the tutorials below
Why It Matters: Microsoft Access Basic Skills
Introduction to Creating Database Tables
Creating a Database
Naming Databases
Creating an Access Table
Introduction to Fields in Access
Field Properties
Field Names and Data Types
Introduction to Table Primary Key
Primary Key
Set a Primary Key
Introduction to Indexes
What is an Index?
To Index or Not to Index?
Student Activity
Putting It Together: Microsoft Access Basic Skills
Assignment: Create New Access Database
Discussion: Selecting Primary Key Tips
Why It Matters: Microsoft Access Intermediate Skills
Introduction to Table Relationships
Database Principles
Flat File vs Normalized Data
Types of Table Relationships
Introduction to Working with Tables
Datasheets
Entering Data
Changing Values
Introduction to Working with Datasheets
Adding Values and Records in Datasheets
Deleting Records in Datasheets
Introduction to Sorting and Filtering Data
Displaying Records in Datasheets
Sorting Data
Aggregating Data
Printing Records
Putting It Together: Microsoft Access Intermediate Skills
Assignment: Modify Access Database
Discussion: Moving Columns and Fields
Why It Matters: Microsoft Access Advanced Skills
Introduction to Importing and Exporting Data
External Data
Import and Export Options
Introduction to Queries
What Are Queries?
Adding Criteria to a Query
Saving Queries
Introduction to Forms and Reports
Understanding Forms
Creating Basic Forms
Form Controls and Views
Presenting Data on Reports
Introduction to Analyzing Data
Transforming Data
Understanding Calculations
Using Conditional Analysis
Using Subqueries
Understanding Domain Aggregation
Putting It Together: Microsoft Access Advanced Skills
Assignment: Create Queries for Access Database
Discussion: Ways to Manage Access Tables