Microsoft Access Core 2002: Working with Advanced Tools in Access

Overview/Description
This course, Microsoft Access Core 2002: Working with Advanced Tools in Access, provides a hands-on introduction to creating, using, and modifying queries, relationships, and data access pages in Access. The course also shows you how to import and export database information.

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:

Using Queries

  • Identify query types
  • Open and view a query
  • Identify components of query Design view
  • Create a select query using a wizard
  • Create a select query in Design view
  • Add fields from multiple tables to a select query
  • Modify a select query in Design view
  • Identify calculation types
  • Add a calculated field to a query
  • Format a calculated field
  • Set criteria for a field

    • Working with Relationships in Access

  • Match data using primary and foreign keys
  • Identify types of relationships
  • Identify components in the Relationships window
  • Add a table to the Relationships window
  • Define a relationship between tables
  • Remove or modify a relationship between tables
  • Identify the conditions and rules of referential integrity
  • Enforce referential integrity between tables

    • Importing, Linking, and Exporting Data and Using Data Access Pages

  • Recognize types of data that can be imported
  • Import data into Access
  • Link data in Access
  • Export a table to another database
  • Export data to another program
  • Export data to an XML document
  • Create a data access page
  • Navigate between data access page views
  • Test a data access page


    • Course Number: MOFF0243