• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 4. Working with Fields > Creating Indexed Fields

Creating Indexed Fields

Just like an index in a book, an index in Access helps you locate and sort information quickly, especially in a very large table. An index in Access is an invisible data structure that stores the sort order of a table based on the indexed field or fields. When you sort a large table by an indexed field, Access consults the index and is able to sort the table very quickly. It can be helpful to index fields you frequently search or sort or fields you join to fields in other tables in queries. If a field contains many different values, rather than many values that are the same, indexing can significantly speed up queries. After indexing a field, you can view and then modify indexes as necessary.

Create a Field Index

Display the table in Design view, and then click a field you want as an index.

Click the Indexed box.

Click the list arrow, and then select one of the following.

  • Yes (Duplicates OK) if you want to allow multiple records to have the same data in this field.

  • Yes (No Duplicates) option if you want to ensure that no two records have the same data in this field.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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