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.
Made with FlippingBook - Online magazine maker