Microsoft Access 2000 Advanced: Advanced Database Functions

Overview/Description
This course, Microsoft Access 2000 Advanced: Advanced Database Functions, describes advanced techniques for linking Access data to other applications, importing and exporting data, integrating with Microsoft Excel, and replicating and synchronizing a database.

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:

Hyperlinks and Linking

  • Create linked fields
  • Create hyperlinks to database objects
  • Use controls to insert hyperlinks in forms
  • Link data from other programs to an Access database

    • Importing, Exporting, and Replicating Data

  • Import and export data
  • Paste tables and queries into Excel
  • Replicate and synchronize a database
  • Convert a database to Access 97 format

    • Additional MOUS Topics

  • Create relationships between tables
  • Join tables to create a query
  • Create a many-to-many relationship
  • Apply filters to a query
  • Optimize data formats


    • Course Number: MOFF0146