Microsoft® Office Access 2003 Inside Out

Chapter 17. Building Tables in an Access Project

Creating a New Project File

Creating a Table in Design View

Defining Columns

Defining a Primary Key

Adding Indexes

Creating Additional Tables in Contact Tracking

Defining Check Constraints

Defining Relationships

Setting Table Design Options

If you worked through the previous chapters in this book, you created all the components and have all the knowledge necessary to produce a fully functioning desktop application in Microsoft Office Access 2003. If you built an application only for your personal use, you might never need to learn more about advanced Access features. But if you plan to share your application with multiple users and/or work with large amounts of data, it might be time to consider building ...