• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Indexing Data

Although not a method of manipulating data like a sort or a filter, indexes provide a method for speeding up searches, sorts, and filters by cataloging the contents of a particular field. The primary key field in a table is automatically indexed. If you have a large database table and frequently search, sort, or filter by a field other than the primary key field, you might want to create an index for that field.

Can't Be Indexed You can't index a field whose data type is Memo, Hyperlink, or OLE Object. There is no way for Access to verify the content of fields containing these types of entries, making it impossible to create an index.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint