To create a single-field index, click the table's name in the Database window and then choose Design to open the table in Design View. In the upper part of the worksheet, click the field that you want to index. In the lower portion, click Indexed and select either Yes (Duplicates OK) or Yes (No Duplicates).