Microsoft® Office Access 2007

77-605: Using Microsoft® Office Access 2007

The Access 2007 exam tests your strength and efficiency in database management utilizing the Access 2007 application.

Passing this exam proves you are especially effective and efficient at structuring databases, creating and formatting database elements, entering and modifying data, creating and modifying queries, presenting and sharing data, and managing and maintaining the overall database.  Become an Office Access 2007 guru.  Get certified today.

The following details the objectives tested on the exam.

Structuring a Database

  • Define data needs and types.
  • Define and print table relationships.
  • Add, set, change or remove primary keys.
  • Split databases.

Creating and Formatting Database Elements

  • Create databases.
  • Create tables.
  • Modify tables.
  • Create fields and modify field properties.
  • Create forms.
  • Create reports.
  • Modify the design of reports and forms.

Entering and Modifying Data

  • Enter, edit and delete records.
  • Navigate among records.
  • Find and replace data.
  • Attach documents to and detach from records.
  • Import data.

Creating and Modifying Queries

  • Create queries.
  • Modify queries.

presenting and Sharing Data

  • Sort data.
  • Filter data.
  • Create and modify charts.
  • Export data.
  • Save database objects as other file types.
  • Print database objects.

managing and Maintaining Databases

  • Perform routine database operations.
  • Manage Databases