O'Reilly logo

Microsoft® Office Access 2007 on Demand by Steve Johnson - Perspection, Inc.

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required