Introduction to Access 2002

Overview/Description
To demonstrate the basic tools and features in Microsoft Access 2002

Target Audience
End-users seeking to become familiar with Microsoft Access 2002; end-users seeking to obtain Microsoft Office User Specialist (MOUS) certification in the use of Microsoft Access 2002 at Core level

Prerequisites
The Microsoft Office XP: Common Features Across Office Applications learning path; familiarity with a Microsoft Windows environment

Expected Duration
265 Minutes

Objectives:

Introduction to Access 2002

  • explain what a database is and describe basic database structures.
  • plan a basic database.
  • launch Access 2002 and describe its interface.
  • create databases in Access 2002.
  • create a blank Access 2002 database and a database based on an Access 2002 template.
  • create tables in Access 2002.
  • create a table using the Access 2002 Table Wizard.
  • modify a table in Access 2002.
  • use the Lookup and Input Mask Wizards.
  • modify a lookup field in Access 2002.
  • create forms and controls in Access 2002.
  • add controls to a form.
  • modify form controls and sections in Access 2002.
  • format form control properties in Access 2002.
  • enter and change database records in Access 2002.
  • manipulate database records.
  • enter and sort database records.
  • use PivotTables and PivotCharts in Access 2002.
  • create a PivotTable and modify a PivotChart in Access 2002.
  • print records in Access 2002.


    • Course Number: 117147_eng