Easy-to-understand Database Tutorials. FatMax Unofficial AQA ICT AS/A2 Resources. Library of Free Data Models. A Design Note on Primary KeysMy approach is very simple and always uses a system-generated unique number as a Primary Key, (except for Reference Data).
This is called a surrogate key, but there is a 'gotcha' which can be deadly. It is all too easy to enter the same record twice. Therefore you must always be sure to enforce a unique constraint on the natural key. Luckily this is easy to do in Access which can be a good basis for clarifying your design and constraints. Why do I do this for free ?