Microsoft® Office Access™ 2007 Plain & Simple

Chapter 5. Creating a Database

In this section:

• Designing a Database

• Creating a New Database

• Creating a New Table in Design View

• Creating a New Table by Typing

• Adding Existing Fields to a Table

• Setting a Primary Key

• Getting Data from Other Access Tables

• Creating Relationships between Tables

• Enforcing Referential Integrity

If none of the databases you can create using one of the Access database templates meets your needs, you can create a database from scratch. When you choose to create a new table, you have complete control over the number of fields, the names of the fields, and what sort of data they can store. After you create the table, you can also add fields from the Field Templates task pane, which contains a wide variety of fields to store such data ...