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