12.17: Discussion- Selecting Primary Key Tips
- Page ID
- 46630
\( \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}}\)
There are many ways to make a primary key or have one automatically generated in Microsoft Access. For additional information about selecting or creating a primary key watch this video which walks through a few examples and discusses various ways to create a custom key for your Access table.
After watching the video ask yourself a few questions and discuss your answers to them.
A link to an interactive elements can be found at the bottom of this page.
Discussion Questions
- Why is it important to choose a memorable primary key?
- Is adding a description important for a primary key? Why or why not?
- In what types of scenarios would you use this information?
Share your opinions below and respond to two of your classmates’ thoughts.
Contributors and Attributions
CC licensed content, Original
- Discussion: Selecting Primary Key Tips. Authored by: Sherri Pendleton. Provided by: Lumen Learning. License: CC BY: Attribution
All rights reserved content
- How To Select and Make PRIMARY KEYS in Microsoft Access. Authored by: Leon Marsden. Located at: https://youtu.be/jpARwLelAek. License: All Rights Reserved. License Terms: Standard YouTube License