Special Edition Using Microsoft® Access 2000

Chapter 4. Working with Access Databases and Tables

In this chapter

• Defining the Elements of Access Databases

• Understanding Relational Databases

• Using Access Database Files and Tables

• Creating a New Database

• Understanding the Properties of Tables and Fields

• Choosing Field Data Types, Sizes, and Formats

• Understanding the Northwind Traders Sample Database

• Adding a New Table to an Existing Database

• Setting Default Values of Fields

• Working with Relations, Key Fields, and Indexes

• Altering Fields and Relationships

• Copying and Pasting Tables

• Troubleshooting

• In the Real World—Database Strategy and Table Tactics

Defining the Elements of Access Databases

The traditional definition of a database is a collection of related data items stored in an organized manner. Access ...