You would select an eligible primary key field rather than have Access assign it as an inflexible.
AutoNumber type.
A relational database table's main key, also known as a primary keyword, is a column that is unique for each record. It serves as a special identity, like the number on a driver's license, a phone number with an area code, or a vehicle identification number (VIN). The main key of a relational database must be unique. There must be a primary key value for every row of data and no row can be null.
In relational databases, the administrator's preferences frequently determine the primary key that is selected. When the particular requirements of the users change, the primary key for a given database can be altered.
To know more about primary key, visit;
brainly.com/question/13437797
#SPJ4
