Using an index


show more Using an index provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Power Shortcuts show less
please wait ...

Using an index

If you perform a lot of searches on one field, you can tell Access to index that field, and index is a stored sort of data, so that when you do a search or filter, Access already knows where that information lies. This speeds up your search results, particularly when you're working with rare or unusual pieces of information within a large number of records. Access's index works a lot like looking up a word in the index at the back of the book, so you can find that term within the chapters. But just like an index in the back of the book, you don't need to turn on a field's index if much of the data is identical.

That would be like looking up the word 'the,' if the data is everywhere then index is of no benefit at all. Your primary key is automatically indexed; you don't have to turn it on manually. I'm in my Customers table and I'll click on the Company field and then I'll go up to the Table tools ribbon and choose Fields and there is a check box for...

Using an index
Video duration: 2m 4s 3h 43m Intermediate

Viewers:

Using an index provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Power Shortcuts

Subject:
Business
Software:
Access
Author:
please wait ...