|
|
You can create a single-field index. Open a table in Design View by clicking the table's name in the Database window and then choosing Design. In the upper part of the worksheet, click the field you want to index. In the lower portion, click Indexed and select either Yes (Duplicates OK) or Yes (No Duplicates).
|