ou can use the Indexed property to set a single-field index. An index speeds up queries on the indexed fields as well as sorting and grouping operations. For example, if you search for specific employee names in a LastName field, you can create an index for this field to speed up the search for a specific name.
Setting
The Indexed property uses the following settings.
Setting Description
No (Default) No index.
Yes (Duplicates OK) The index allows duplicates.
Yes (No Duplicates) The index doesn't allow duplicates.
You can set this property only in the Field Properties section in table Design view. You can set a single-field index by setting the Indexed property in the Field Properties section in table Design view. You can set multiple-field indexes in the Indexes window. To open the Indexes window, on the Design tab, in the Show/Hide group, click Indexes.
If you add a single-field index in the Indexes window, Microsoft Access will set the Indexed property for the field to Yes.
In Visual Basic , use the ADO Append method of the Indexes collection to create an index for a field.
Remarks
Use the Indexed property to find and sort records by using a single field in a table. The field can hold either unique or non-unique values. For example, you can create an index on an EmployeeID field in an Employees table in which each employee ID is unique or you can create an index on a Name field in which some names may be duplicates.