Whether you use Microsoft Access to keep track of inventory or to keep a record of customers and clients, managing your tables can become cumbersome as the database grows in size and complexity.

When you create a Microsoft Access table, Access will automatically create a primary key to your database table, but you can also specify the field you want as the primary key for your database table.