This dialog provides options for the creation of a new index.
The Set Index dialog has the following components:
Index information Provides information on the index.
Index name Enter a name for the index.
Unique index Select Unique index to ensure that values are unique and not null.
Unique key Select Unique key to ensure that values are unique. They may be null.
Indexed Columns Allows you to add or remove columns from the index.
Columns in the table Lists all columns in the table that are not in the index. Click a column to select it, or hold down Control to select more than one column at a time.
Asc.>> Click Asc.>> to add one or more columns, chosen from the Columns in table list, to the index in ascending order.
Desc.>> Click Desc.>> to add one or more columns, chosen from the Columns in table list, to the index in descending order.
<< Click << to remove one or more columns, chosen from the Columns in the index list, from the index.
Columns in the index Lists all columns in the index. Click a column to select it, or hold down Control to select more than one column at a time.