Microsoft Access 97 Intermediate: Manipulating Data, Advanced Queries

Overview/Description
This course, Microsoft Access 97 Intermediate: Manipulating Data, Advanced Queries, discusses intermediate techniques including creating customized and advanced queries, and manipulating data and objects.

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:

Manipulating Data and Objects

  • Review basic Access operations
  • Copy, rename, and delete database objects
  • Link to a table

    • Creating Customized Queries

  • Calculate totals in queries
  • Specify total criteria
  • Create a customized expression
  • Create a make-table query
  • Create an update query

    • Creating Advanced Queries

  • Create parameter queries
  • Specify multiple criteria
  • Create a crosstab query
  • View SQL statements


    • Course Number: MOFF0033