Access 2016 Advanced

Lesson 6 – Working with Indexes

Access 2016

V IEWING I NDEXES



Discussion

Use indexes to help Access perform quicker sorts and searches. Index the fields you use regularly to sort or search for data.

Indexes have important properties listed in the following table:

Property

Description

Primary

Designates whether or not the index is the primary key for the table. In other words, this property designates whether or not the data in the indexed field is used to uniquely identify each record. If this property is set to Yes , the Unique property must be set to Yes . Designates whether the values in the indexed field must be unique for each record. Set this property to Yes without setting the Primary property to Yes . Determines whether records with null values in the indexed field are included in the index. The default setting is No , meaning null values are included.

Unique

Ignore Nulls

The Indexes window

NOTE You cannot create an index for Memo , OLE , or Hyperlink fields.

Page 66

OFFICEPRO, Inc.