Skip to main content
Business LibreTexts

12.13: What is an Index?

  • Page ID
    46626
  • \( \newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \) \( \newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}} \)\(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\) \(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\)

    Learning Objectives

    • Define indexes
    • Set the properties of indexes

    Imagine that you collect business cards in order to keep track of your professional contacts. Over time your collection of cards becomes quite large. You want to know which of your contacts work for Company Z, so you must read each and every card in order to develop your list. This could take quite a bit of time. But what if you had dog-eared the cards from Company Z beforehand? Would that have reduced the time it took you to find that select group of contacts?

    Indexing a table enables Access to establish a sort order on the data in the indexed field. Without an index, Access would have to search each and every field—much in the same way you would have to look through each and every business card.

    Index Properties

    Indexes in Access have properties too.

    • Primary. This property, when set to Yes, tells Access to use it as the table’s primary key.
    • Unique. This property requires that the index is unique within the table.
    • Ignore Nulls. If the index field of a record contains a null value, Access does not know how to handle the record. This property tells Access to ignore such records.

    Contributors and Attributions

    CC licensed content, Original
    • What is an Index?. Authored by: Robert Danielson. Provided by: Lumen Learning. License: CC BY: Attribution

    12.13: What is an Index? is shared under a CC BY license and was authored, remixed, and/or curated by LibreTexts.

    • Was this article helpful?