Access Beginner 1 Lessons

Primary Key Existing Field Upload Images Link
Matthew Rafferty
2 years ago

Hi Rick,

If my student database includes students that already have a unique ID assigned e.g. a personnel number, shoulder that number be the primary key? Thanks PS Really enjoying the Learning zone!

Richard Rost
2 years ago

I recommend against it. I like to use an Autonumber for the primary key because Access will assign it and maintain it. The user can't edit it. Technically the user never even has to see it or know what it is. If you want to add that Personnel Number as an additional field for searching, that's perfectly fine. Index it, no duplicates. But don't make it the primary key. Later on when you get to relationships in Expert Level 1, you'll see why Autonumbers are best for PKs.

Richard Rost
2 years ago

That's a good question. I get asked it a lot. Maybe I'll turn this into a TechHelp video. :)

Richard Rost
2 years ago

See: AutoNumbers Good or Bad?

This thread is now closed. If you wish to comment, start a NEW discussion, below.

Back to Access Beginner 1 Lessons Comments