Microsoft Access 2002 Core: Working with Forms, Reports, Filters, and Sorts

Overview/Description
This course, Microsoft Access Core 2002: Working with Forms, Reports, Filters, and Sorts, provides a hands-on introduction to creating, using, and modifying forms, reports, filters, and sorts in Access.

Target Audience
Microsoft Access beginners or those new to Microsoft Access 2002. The learner should be able to navigate the basic Microsoft Windows XP interface.

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

Objectives:

Creating and Modifying Forms

  • Create a form using AutoForm
  • Create a form using the Form Wizard
  • Open a form and navigate through records
  • Add and delete records
  • Identify components of form Design view
  • Add controls using the field list
  • Identify controls in the toolbox
  • Add controls using the toolbox
  • Move, resize, and delete controls
  • View and identify form and control properties
  • Modify form and control properties
  • Add a subform to a form
  • Change tab order

    • Producing Reports

  • Create a report using AutoReport
  • Create a report using a wizard
  • Open and view reports
  • Identify the components of report Design view
  • Add, delete, and align fields in a report
  • Add a calculated control to a report
  • Group and sort records in a report
  • Add page numbers and dates to a report
  • Format a report with AutoFormat
  • Use the Formatting toolbar
  • Modify page setup
  • Preview and print a report

    • Finding, Sorting, and Filtering Information

  • Identify tools for locating information in a database
  • Find and replace information in a table, query, or form
  • Sort records in a table, query, or form
  • Differentiate filter types
  • Filter records by selection
  • Filter records by form


    • Course Number: MOFF0242