Does Access automatically creates and maintains an index for a table's primary key?
Access automatically creates an index for the primary key field
in a table. In addition, Access automatically creates an index for
any field name that contains the following letter sequences: code,
ID, key, or num.