Special Edition Using Microsoft Office Access 2003

In this chapter

Understanding Jet Database Files

Creating a New Jet Database

Exploring the Properties of Tables and Fields

Choosing Field Data Types, Sizes, and Formats

Working with the Northwind Traders Sample Database

Preparing to Add a Table Related to the Employees Table

Designing the HRActions Table

Setting Default Values of Fields

Working with Relations, Key Fields, and Indexes

Altering Fields and Relationships

Working with Object Dependencies and Access Smart Tags

Copying and Pasting Tables

Using the Table Analyzer Wizard

Generating a Data Dictionary with the Database Documenter

Troubleshooting

In the Real World Database Strategy and Table Tactics