MCAS Office 2007 Exam Prep: Exams for Microsoft Office 2007

Part VI: MCAS 77-605: Using Microsoft Office Access 2007

Chapter Twenty-OneStructuring a Database

Objectives

This chapter helps you prepare for the MCAS: Using Microsoft Office Access 2007, Exam 77-605, by covering the following Microsoft objectives:

• Navigate among records.

• Define data needs and types.

• Create databases.

• Create tables.

• Modify tables.

• Create fields and modify field properties.

• Define and print table relationships.

• Add, set, change, or remove primary keys.

• Enter, edit, and delete records.

• Find and replace data.

• Attach documents to and detach from records.

• Split databases.

Outline

Introduction	650
Database Basics	650
Organizing Data for a Database	651
Record Keys	653
Create a Database in Access ...