Microsoft Access 2000 Intermediate: Customizing Reports, Adding Links

Overview/Description
This course, Microsoft Access 2000 Intermediate: Customizing Reports, Adding Links, describes intermediate-level techniques for creating reports that group and sort data, using Access with the Web and intranets, using field formats and input masks, and compacting and repairing a database.

Target Audience
This course requires that you have a working knowledge of basic Access operations.

Expected Duration
This course, including the practice exercises, will take up to 4 hours to complete.

Objectives:

Customizing Reports

  • Create customized reports
  • Group and sort report data
  • Enhance reports
  • Create reports that contain subreports

    • Using Access with the Web and Intranets

  • Add hyperlink fields to tables
  • Insert and format hyperlinks in fields
  • Export table data to Web pages
  • Create data access pages

    • Additional Access Skills

  • Create and use field formats
  • Create and use field input masks
  • Create field rules to validate data entry
  • Compact and repair databases
  • Enforce referential integrity


    • Course Number: MOFF0144