Intermediate Access 2002

Overview/Description
To provide an overview of the features and tools in Access 2002 for the intermediate end-user

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
225 Minutes

Objectives:

Intermediate Access 2002

  • establish relationships between database tables and enforce referential integrity.
  • establish a relationship between tables in a database.
  • create and modify queries in Access 2002.
  • create and specify a query in Access 2002.
  • work with relationships and queries in Access 2002.
  • describe the different report types, report sections, and report controls and create a report using the Report Wizard in Access 2002.
  • add a field and a control to a report in Access 2002.
  • modify report controls and sections in Access 2002.
  • use report controls.
  • navigate and print reports in Access 2002.
  • create a report in Access 2002.
  • import and export data using Access 2002.
  • import data into Access and export data to Excel.
  • add hyperlinks to datasheets, tables, and forms in a database.
  • create a hyperlink in Access 2002.
  • describe how to compact a database and split one using the Database Splitter utility.
  • save, convert, and back up data in Access 2002.


    • Course Number: 117172_eng