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.

You can view the transcript for “How to Select and Make PRIMARY KEYS in Microsoft Access” here (opens in new window).

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.