Microsoft Access - Class 2 - Part IX
|
>
Back |
Indexing a Single Field
To create or remove an index based on a single field, open the
table in Design View and select a value for the Indexed property:
- No means there is no index based on the field. This is the default.
- Yes (Duplicates OK) creates an index based on the field and lets
you enter the same value in any number of records in the field.
To be used to speed up searches and sorts based on a field.
- Yes (No Duplicates) creates an index based on the field and does
not let you enter a value in the field if that value has already
been entered in another record. This is the one used for primary
keys and you cannot change its index property as long as it remains
a primary key.
Indexing on Multiple Fields
Indexing on multiple fields is also possible in Access. You can
enter the name for the index, select the field that you want to
index and specify whether it should be sorted in ascending or descending
order. You should also make sure that the index's properties are
what you want.
Print this page
|
