How to Create a Relationship in Microsoft Access How to ... Make whatever changes you want to make. To Delete a Relationship, you must remove the line from the two tables; these are the measures.

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.