Microsoft Access 2000 Advanced: Forms, Tables, and Macros

Overview/Description
This course, Microsoft Access 2000 Advanced: Forms, Tables, and Macros, describes advanced database techniques including creating macros, making databases more efficient, inserting graphics and charts, and protecting databases.

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

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

Objectives:

Working with Macros

  • Create AutoKeys macros
  • Assign macros to events
  • Create conditional macros
  • Assign conditional macros to events

    • Working with Tables

  • Index tables
  • Normalize tables
  • Create and modify a Lookup field
  • Create and modify PivotTables
  • Customize table fields
  • Create an input mask

    • Working with Forms and Graphics

  • Create a switchboard
  • Insert command buttons into forms
  • Insert graphics
  • Create graphs

    • Customizing Microsoft Access

  • Customize toolbars
  • Modify command settings
  • Set and modify passwords
  • Encrypt and decrypt databases


    • Course Number: MOFF0145