Adding Indexes

The more data you include in your tables, the more you need indexes to help Microsoft Access 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 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 Contacts table by city. Without an index, when you ask Access to find all the Contacts who live in the city of Chicago, Access has to search every record in ...

Get Microsoft® Office Access 2003 Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.