Microsoft® Office Access 2003 Inside Out

Understanding Other Table Properties

As you can see in Figure 4-27, Access provides several additional table properties that you can set in Design view. You can enter a description of the table on the first line, and you’ll see this description in the Database window if you select the details view. For Default View, you can choose from Datasheet (the default), PivotTable, or PivotChart. You can read more about PivotTable and PivotChart views in Chapter 13.

The Filter property lets you predefine criteria to limit the data displayed in the Datasheet view of this table. You can use Order By to define one or more fields that define the default display sequence of rows in this table when in Datasheet view. If you don’t define an Order By property, Access ...