Model a Database Index
A database index on a database Table is used to improve the performance of lookups and sort operations on the Table at the expense of additional storage.
Access Tools | Database Builder | Click on Table name > Constraints | Right-click | Add New Constraint (Ctrl+N)
A new constraint is added to the Constraints tab, with the default type index. See the Help topic Database Indexes for information on defining the new index.
To delete a database index you no longer require, right-click on the index name on the Constraints tab and select the Delete constraint <name> option. The index is immediately removed.