Create an index to find and sort records faster (MDB)

1. Open a table in Design view.
2. In the upper portion of the window, click the field that you want to create an index for.
3. In the lower portion of the window, click in the Indexed property box, and then click Yes (Duplicates OK) or Yes (No Duplicates).

1. Open the table in Design view.
2. Click Indexes on the toolbar.
3. In the first blank row in the Index Name column, type a name for the index. You can name the index after one of the index fields, or use another name.
4. In the Field Name column, click the arrow and select the first field for the index.
5. In the next row in the Field Name column, select the second field for the index. (Leave the Index Name column blank in that row.) Repeat this step until you have selected all the fields you want to include in this index.

Note  The default sort order is Ascending. Select Descending in the Sort Order column of the Indexes window to sort the corresponding field's data in descending order.