Still, you can also specify the field you want as the primary key for your database table. The Primary key in Microsoft Access is a field or set of fields with unique values throughout the table.

Which makes for a better primary key: natural data points or meaningless values? Database developers have strong opinions on this facet of primary key design. This article settles the debate once ...

Primary key A primary key is a field used to uniquely identify every record in the database. Sometime primary keys are obvious, for example a car license plate could be used to uniquely identify cars.