Microsoft Access Training Home

An Introduction to Databases
What is Access?
Database Objects
Desktop Databases and Access Web Apps
Components of the Access User Interface
Looking at the Screen
Starting Access and Working with Database Files
Using the Navigation Pane
Saving and Exporting Databases
Setting Access Options

Table Basics
Data Types
Table Views
Creating Tables in Design View
Modifying Tables in Design View
Primary Keys
Creating Tables in Datasheet View
Reusing Design Elements
Importing Data
Working in Datasheet View
Constraining Input
Table Relationships
Viewing Related Data

Retrieving Data
Finding Records
Sorting Records
Filtering Records
Creating Queries
Modifying Queries
Adding Query Criteria
Working with Joined Tables
Performing Calculations in Queries
Grouping and Summarizing Query Data
Creating Parameter Queries
Using Conditional Logic in a Query
Creating Action Queries
Creating Crosstab Queries

Why Use Forms?
Form Types
Form Views
Creating Forms Using Automated Tools
Creating Forms from Scratch
Modifying Forms
Working with a Form in Layout view
Working with a Form in Design View
Adding Controls from the Ribbon
Adding Subforms
Ensuring Accuracy
Formatting Forms

What is a Report?
Report Views
Creating Reports
Creating a Report Using the Report Wizard
Creating a Report Using Application Parts
Creating a Blank Report
Working with Reports
Working with Reports in Design View
Formatting Reports
Previewing and Printing Reports

Protecting Database Files
Maintaining Database Files
Managing Databases
Creating Templates and Application Parts