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.
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.