Although not a method of manipulating data like a sort or a filter, indexes provide a method for speeding up searches, sorts, and filters by cataloging the contents of a particular field. The primary key field in a table is automatically indexed. If you have a large database table and frequently search, sort , or filter by a field other than the primary key field, you might want to create an index for that field.
Can't Be Indexed You can't index a field whose data type is Memo, Hyperlink, or OLE Object. There is no way for Access to verify the content of fields containing these types of entries, making it impossible to create an index.
To index a field, follow these steps:
Indexes aren't glamorous. They work behind the scenes to speed up your searches and filters. They don't really have any independent functions of their own.
In this lesson, you learned how to sort, filter, and index your database tables. In the next lesson, you learn how to create a query using the Query Wizard.