Access 2016 Advanced

Lesson 6 – Working with Indexes

Access 2016

3. Click the row selector to the left of the row containing the index you want to delete. 4. Press [Delete] .



Step-by-Step

Delete an index.

Open the Packing Slip 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. Click the row selector to the left of the row containing the index you want to delete. The row is selected.

Click

Click the row selector to the left of the Prod ID field in the Index Name column

3. Press [Delete] .

Press [Delete]

The index is deleted.

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

C REATING A M ULTIPLE F IELD P RIMARY K EY



Discussion

There are times when it is not possible to uniquely identify fields with the values in a single field. Therefore, Access allows you to create a primary key using multiple fields.

When you set a primary key using multiple fields, the combination of the information in the fields must be unique. For example, a table that contains line items for customer orders may have an order number for each customer. Because you will most likely have multiple customers with multiple orders, the order number associated with each customer may not be unique. Also, a particular item number may appear in multiple orders. Therefore, the item numbers may not be unique. Thus, you cannot create a primary index on either of these fields by themselves. The

Page 72

OFFICEPRO, Inc.