Whenever coming up with new tables in MS Access or redesigning existing tables, expert MS Access consultants want to make sure that every table should possess a column, or two or three columns, that uniquely identifies every record stored within the MS Access database table. Some Access database designers use unique identification numbers, such as social security numbers, employee Id numbers or product serial numbers. MS Access database designers, along with alternative database designers for different sorts of databases call this the table’s primary key. MS Access uses primary key fields to index, i.e., immediately group together information from multiple tables and marshal the data as one.

(more…)