Microsoft Access 2000 Intermediate: Advanced Queries, Customized Forms

Overview/Description
This course, Microsoft Access 2000 Intermediate: Advanced Queries, Customized Forms, presents techniques for manipulating database objects, creating queries that do calculations and perform actions, creating queries that prompt users for input, and customizing forms with controls and subforms. It also discusses use of SQL, the standard database language.

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

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

Objectives:

Creating Advanced Queries

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

    • Creating Customized Queries

  • Calculate totals in queries
  • Add criteria to a totals query
  • Use calculations in a totals query
  • Create Make-Table queries
  • Create Update queries

    • Customizing Forms

  • Create custom forms
  • Add bound, unbound, and calculated controls to forms
  • Using list boxes and combo boxes
  • Enhance forms with lines, colors, and sections
  • Create relationships between tables
  • Create and use subforms


    • Course Number: MOFF0143