Access 2016 Advanced

Access 2016

Lesson 6 - Working with Indexes

E XERCISE

W ORKING WITH I NDEXES



Task

Work with indexes.

1. Open INDEX1X.ACCDB . 2. Open the Invoice table in Design view. 3. Index the Client ID field, allowing duplicates. 4. Open the Indexes dialog box.

5. Create a multiple field index called Client/Project . The first field in the index should be Client ID and the second field should be Project ID . Use the Ascending sort order for both. 6. Close the Indexes dialog box . Then, close the Invoice table without saving the changes. 7. Open the Project table in Design view. 8. Open the Indexes dialog box and delete the existing indexes. Close the Indexes dialog box . 9. Create a multiple field primary key that includes the Project ID and Client ID fields. 10. Open the Indexes dialog box to view the primary key fields. Then, close the Indexes window. 11. Close the Project table without saving the changes. 12. Close the database file.

OFFICEPRO, Inc.

Page 75