Microsoft Access 97 Introduction: Creating Queries and Reports

Overview/Description
This course, Microsoft Access 97 Introduction: Creating Queries and Reports, discusses techniques for finding, replacing, and sorting table data, querying a database, and designing a report.

Target Audience
This course requires that you have a general understanding of basic personal computer operations and basic database techniques such as working with database tables, and entering and modifying data.

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

Objectives:

Finding, Sorting, and Replacing Table Data

  • Locate specific records
  • Modify specific records
  • Filter records in a table
  • Sort records in a table
  • Create Lookup fields and OLE Object fields

    • Querying a Database

  • Query a single table
  • Modify query fields
  • Produce calculations in a dynaset
  • Query multiple tables
  • Print records in a dynaset

    • Designing a Report

  • Create reports
  • Customize and print reports
  • Generate mailing labels


    • Course Number: MOFF0032