Microsoft® Office Access 2007 on Demand

3. Planning and Creating a Custom Database

What You’ll Do

Create a Custom Database Template

Plan Tables

Create Tables in a Database

Create a Table by Entering Data

Create a Table Using a Template

Import Data into Tables

Link to Data in Tables

Working with Table Records

Work with a Table in Design View

Specify a Primary Key in Design View

Plan Table Relationships

Define Table Relationships

Create and Print a Table Relationship Report

Ensure Referential Integrity

Identify Object Dependencies

Modify Object Dependencies

Introduction

The Microsoft Office Access 2007 database wizards make creating databases easy, but you may need to create a database that does not fit any of the predefined template choices. In that situation, you may need to create ...