Skip to main content
Workforce LibreTexts

5.11: Set a Primary Key

  • Page ID
    14809
  • \( \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 Outcomes

    • Set the primary key

    A primary key can be set for a table in one of three ways. Open a table in Design view and:

    • With the field to be used as the primary key selected, click the Primary Key button key in the Tools group.
    • Right-click the appropriate field and choose Primary Key from the shortcut menu.
    • Allow Access to automatically create the primary key by simply saving the table.

    In this example, Field One was highlighted and Primary Key was selected in the Menu bar to designate it as the Primary Key.

    Microsoft Access screenshot showing Field One highlighted and Primary Key selected in the menu bar.

    Contributors and Attributions

    CC licensed content, Original
    • Set a Primary Key. Authored by: Robert Danielson. Provided by: Lumen Learning. License: CC BY: Attribution

    5.11: Set a Primary Key is shared under a not declared license and was authored, remixed, and/or curated by LibreTexts.

    • Was this article helpful?