Computer Training

Access - Introduction

Course Prerequisites

  • Required: Knowledge of Windows Introduction topics and ability to use keyboard and mouse. Recommended: Use of one or more other programs, such as Excel or Word.

SECTION 1: Starting Out

Lesson 1.1: Starting Out

  • What is Microsoft Access
  • What is new in Access 2003
  • Basic Terminology
  • Opening Microsoft Access
  • Interface Overview
  • Closing Microsoft Access
  • Practice Exercise

Lesson 1.2: Using The Access Interface

  • Using The Access Menus
  • Using Access Task Panes
  • Using Toolbars
  • Adding, Removing, And Moving Toolbars
  • Using The Switchboard
  • Using The Database Window
  • Practice Exercise

Lesson 1.3: Getting Help

  • Using The Help Menu
  • Using The Help Task Pane
  • Using The Office Assistant
  • Configuring The Office Assistant
  • Using The Type A Question Box
  • Getting Help In A Dialog Box
  • Using The Sample Databases
  • Practice Exercise

Section 1: Review Questions

back to top

SECTION 2: Creating A Database

Lesson 2.1: First Steps

  • Planning A Database
  • Creating A Blank Database
  • Using Database Objects
  • Practice Exercise

Lesson 2.2: Records

  • What Is A Record?
  • Adding Records
  • Editing Records
  • Deleting Records
  • Printing Records
  • Practice Exercise

Lesson 2.3: Creating A Table

  • About Tables
  • Creating A Table In Design View
  • Creating A Table Using The Wizard
  • Entering Data Into A Table
  • Formatting A Table
  • Practice Exercise

Lesson 2.4: Formatting Text

  • Using The Zoom Toolbar
  • Selecting Data
  • Cutting, Copying And Pasting
  • Using The Format Painter
  • Using Undo And Redo
  • Checking Your Spelling
  • Practice Exercise

Lesson 2.5: Formatting Controls

  • Changing The Color Of A Control
  • Using Control Properties
  • Aligning Controls
  • Applying Special Effects
  • Practice Exercise

Section 2: Review Questions

back to top

SECTION 3: Doing More With Your Database

Lesson 3.1: Creating Forms

  • What Is A Form?
  • Bound Vs Unbound Controls
  • Creating A Form With The Wizard
  • Creating A From In Design View
  • Using Forms
  • Practice Exercise

Lesson 3.2: Creating Queries

  • What Is A Query?
  • Creating A Query With The Wizard
  • Using Design View To Modify A Query
  • Using Queries
  • Practice Exercise

Lesson 3.3: Reports

  • What Is A Report?
  • Creating A Report With The Wizard
  • Creating A Report In Design View
  • Using Reports
  • Practice Exercise

Lesson 3.4: Sorting And Filtering Data

  • Using Find And Replace
  • Sort Ascending Or Descending
  • Using Filter By Form
  • Using Filter By Selection
  • Creating A Filter
  • Practice Exercise

Section 3: Review Questions

back to top

SECTION 4: Viewing And Printing Your Data

Lesson 4.1: Formatting A Data Sheet

  • Adjusting Row Height And Column Width
  • Rearranging Columns
  • Freezing A Row Or Column
  • Hiding A Column
  • Changing The Datasheet Font
  • Practice Exercise

Lesson 4.2: Viewing Data

  • Using The View Menu
  • Using The Window Menu
  • Hiding And Unhiding Windows
  • Arranging Windows
  • Closing Individual Windows
  • Practice Exercise

Lesson 4.3: Printing A Database Object

  • Using The Print Icon
  • Using Print Preview
  • Using Page Setup
  • Practice Exercise

Section 4: Review Questions

back to top