Microsoft® Office Access 2003 Inside Out

Chapter 4. Creating Your Database and Tables

Creating a New Database

Creating Your First Simple Table by Entering Data

Creating a Table Using the Table Wizard

Creating a Table in Design View

Defining Fields

Defining a Primary Key

Defining a Table Validation Rule

Understanding Other Table Properties

Defining Relationships

Adding Indexes

Setting Table Design Options

Printing a Table Definition

Database Limitations

After you design the tables for your database, defining them in a Microsoft Access desktop database (.mdb file) is incredibly easy. This chapter shows you how it’s done. You’ll learn how to

• Create a new database application using a database template

• Create a new empty database for your own custom application

• Create a simple table by entering data directly ...