Databases with Microsoft Access 10 –Field Indexing, Primary Keys, Index Creation
Creating Index for field brings with it:
Sorting field is faster
Searching field is faster
Indexing makes sense for fields with lots of different content
Indexing costs memory space and database response times
All fields, with exception of OLE-fields can be indexed.
You can index one or more fields
Three types of Indices
With duplicates
Without duplicates
Primary keys
Primary Key is main index of table
Does not allow duplicates
Each table can have only one primary key
Recommendation for each table you create in Access
Create field, which contains unique data for each record
Endow this field with primary key