Special Edition Using Microsoft® Office Access 2003

Chapter 5. Working with Jet Databases and Tables

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

Understanding Jet Database Files

The traditional name for ...