Microsoft Access 2002 Core: Opening, Creating, and Using Databases

Overview/Description
This course, Microsoft Access 2002 Core: Opening, Creating, and Using Databases, provides a hands-on introduction to creating, formatting, and managing Access databases.

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:

Opening, Creating, and Using Databases

  • Recognize the structure of a database
  • Start Access
  • Open an existing database
  • Identify elements in the Access environment
  • Get Help in Access
  • Plan a database
  • Create a blank database
  • Create a database using the Database Wizard
  • Use the Objects bar
  • Open and view tables
  • Open and view queries
  • Open and view forms
  • Open and view reports

    • Creating and Modifying Tables

  • Create a table using the Table Wizard
  • Create a table in Design view
  • Open a table and select a record
  • Add, edit, and delete records in a table
  • Navigate through records
  • Format datasheets
  • Insert, delete, and move fields
  • Identify data types
  • Set the data type of a field
  • Create lookup lists

    • Controlling Table Data Using Field Properties

  • Recognize field properties
  • Set a field size
  • Set validation rules and validation text
  • Set default values and required fields
  • Index fields
  • Recognize the uses of input masks
  • Identify elements of the Input Mask Wizard
  • Create a predefined input mask for a field
  • Create a custom input mask for a field
  • Format fields


    • Course Number: MOFF0241