Create a multiple-field index

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 some other appropriate 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. You can use up to 10 fields.

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.