1002
Chapter 37 Customizing Tables, Forms, and Reports
the name of the index, the fields it should include (up to 10), and the sort order for each
one. This same dialog box lets you view and edit or delete existing indexes.
37
Defining Relationships Between Tables
A well-designed Access database typically contains many interrelated tables, with each table
containing a specific, narrowly defined set of data, without any duplicate information. This
type of design is crucial to maintaining referential integrity—when you change a name,
address, or other piece of data in one record, your change automatically appears in all
related tables.
Imagine a database ...