Home
About Jeanina
References
On Site Classes
Adult Education Classes
Technology Training Center

Introduction to Microsoft Access

Jeanina Sargent (717) 586-1878

jeanina@sargentsoftware.com

 

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