Skip to main content
Business LibreTexts

12.11: Set a Primary Key

  • Page ID
    46624
  • \( \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}}\)\(\newcommand{\AA}{\unicode[.8,0]{x212B}}\)

    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

    12.11: Set a Primary Key is shared under a CC BY license and was authored, remixed, and/or curated by LibreTexts.

    • Was this article helpful?