This article introduces indexes and covers how to decide which fields to index, and how to create, delete, or change an index.

Another source of automatic index creation is the Auto Index on Import/Create option in the Access Options dialog box.

Access automatically indexes any fields with names that begin or end with the characters entered in the Auto Index on Import/Create box, such as ID, key, code, or num.

For example, you can create a unique index on a field that stores serial numbers so that no two products have the same serial number.

Create a single-field index Create a multiple-field index To create a multiple-field index for a table, you include a row for each field in the index and include the index name only in the first row.

Access treats all rows as part of the same index until it comes to a row containing another index name.

To insert a row, right-click the location where you want to insert a row, and then click Insert Rows on the shortcut menu.

You can include up to 10 fields in a multiple-field index.

To create an index, you first decide whether you want to create a single-field index or a multiple-field index.

To see or change the current setting, take the following steps: Because each additional index requires Access to do additional work, performance decreases when adding or updating data.