Introduction to Microsoft Access

This introductory class teaches students the basic skills they need to create databases. Students will learn how to creates tables, forms, queries and reports.

Making the data retrieval “Easy” is the goal of this class.

Getting Started in Access

• Database Basics
• The Access Screen
• Accessing Help

Working With Tables

• Creating a Database
• Creating a Table
• Restructuring a Table

Entering Data Into a Table

• Opening a Database
• Viewing a Table
• Editing a Table
• Using AutoCorrect
• Using the Spell Checker

Manipulating a Table

• Resizing The Table
• Resizing a Column
• Hiding/Unhiding/Freezing/Unfreezing Columns
• Sorting The Data

Creating Forms (Wizard and Design Mode)

• Creating Forms
• Customizing Forms
• Displaying the Toolbox
• Using the Format Painter

Querying Data From Tables

• Querying Tables
• Compound Queries
• Creating Calculated Fields

Creating Reports (Wizard and Design Mode)

• Creating Reports
• Customizing Reports