Microsoft® Access® 2010 Inside Out

Chapter 4. Designing Client Tables

• Creating a New Database

• Creating Your First Simple Table by Entering Data

• Creating a Table Using Application Parts

• Creating a Table Using Data Type Parts

• 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 Access 2010 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 ...