Access 2016 Advanced

Access 2016

Lesson 6 - Working with Indexes

C REATING A M ULTIPLE F IELD I NDEX



Discussion

If you often search on a combination of fields, index multiple fields to speed up the searches and sorts. For example, if you want to sort customers in order by region and alphabetically within each region, create an index on the Region and Customer fields.

Create a multiple field index in the Indexes dialog box. List all the fields you want to include in the index under the same index name. You can include up to ten fields in an index.



Procedures

1. Open the desired table in Design view.

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

.

3. Select the first blank field in the Index Name column. 4. Type the index name. 5. Press [Tab] . 6. Select the Field Name list. 7. Select the field you want to index. 8. Press [Tab] . 9. Select the Sort Order list. 10. Select the desired sort order. 11. Select the next blank field in the Field Name column. 12. Select the Field Name list. 13. Select the field you want to index. 14. Press [Tab] . 15. Select the Sort Order list.

16. Select the desired sort order. 17. Close the Indexes dialog box.

OFFICEPRO, Inc.

Page 69