Why This Chapter Is Important

Once you have created a database, you are ready to add other objects to it. Generally, the first objects that you add to a database are the tables that it contains. After you add the tables, you establish relationships between them. This chapter shows you how to create tables. When you understand how to create tables, you will want to refine the properties of those tables. The chapter shows you how to create defaults and how to add and modify constraints. You will also learn how to create your own data types and how to add and modify indexes. Finally, you will learn how to use database diagrams to establish relationships between the tables contained in your databases.

Get Alison Balter's Mastering Access 2002 Enterprise Development now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.