Microsoft Office® Access 2007 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 a Table Template

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

Creating a Default Template for New Databases

Printing a Table Definition

Database Limitations

Defining tables in a Microsoft Office Access 2007 desktop database (.accdb 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 ...