Access 2016 Advanced

Access 2016

Lesson 6 - Working with Indexes

Steps

Practice Data

10. Select the next blank field in the Field Name column.

Click the next blank field in the Field Name column below the Customer ID entry

The insertion point appears in the Field Name column and an arrow appears to the right of the field.

11. Select the Field Name list.

Click Field Name

A list of the field names in the table appears.

12. Select the field you want to index. The field name appears in the Field Name column .

Click the Order Number field

13. Press [Tab] .

Press [Tab]

The insertion point appears in the Sort Order column and an arrow appears to the right of the field .

14. Select the Sort Order list. A list of sort orders appears.

Click Sort Order

15. Select the desired sort order.

Click Ascending

The desired sort order appears in the Sort Order column .

Close the Indexes window. Close the table without saving the changes.

D ELETING AN I NDEX



Discussion

Indexes take up disk space and can slow down adding, editing, and deleting records. In fact, if there are a limited number of different values in a field, the sort or search speed is not significantly increased by indexing the field. Therefore, you can delete any unwanted indexes to increase efficiency.



Procedures

1. Open the desired table in Design view.

2. On the Design tab in the Show/Hide group click the Indexes button

.

OFFICEPRO, Inc.

Page 71