Access 2016 Advanced

Lesson 6 – Working with Indexes

Access 2016



Step-by-Step

Create a multiple field index.

If necessary, open the Orders table in Design view.

Steps

Practice Data

1. On the Design tab in the Show/Hide group click the Indexes button. The Indexes dialog box opens. 2. Select the first blank field in the Index Name column. The insertion point appears in the first blank field in the Index Name column.

Click

Click the first blank field in the Index Name column

3. Type the index name.

Type Orders by Customer

The name appears in the Index Name column.

4. Press [Tab] .

Press [Tab]

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

5. Select the Field Name list.

Click Field Name

A list of the field names in the table appears.

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

Click the Customer ID field

7. Press [Tab] .

Press [Tab]

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

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

Click Sort Order

9. Select the desired sort order.

Click Ascending

The desired sort order appears in the Sort Order column .

Page 70

OFFICEPRO, Inc.