Adding indexes

The more data you include in your tables, the more you need indexes to help Access 2013 search your data efficiently. An index is simply an internal table that contains two columns: the value in the field or fields being indexed and the physical location of each record in your table that contains that value. Access uses an index similarly to how you use the index in this book—you find the term that you want and jump directly to the pages containing that term. You don’t have to leaf through all the pages to find the information you want.

Let’s assume that you often search your Vendors table by city. Without an index, when you ask Access to find all the contacts in the city of Seattle, Access has to search every record in your table. ...

Get Microsoft Access 2013 Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.