Need help with Database for Access (Intro to Relational Database)

Northwind Traders is an international specialty foods distributor that relies on an Access database to track customers and process its orders. A make table query moved all the owners from the Customers table to a new Customer Owners table. A colleague converted a copy of the make table query to an append query and ran it again (expecting it would not add another set of records). Unfortunately, it did add the same set of owners to the table, and now every owner is duplicated. Consider the best way to fix this problem. You need the append query so that you can run it when new owners are added to the database. However, running the append query should not add duplicate records to the Customer Owners table. Open a06d1Food and save it as a06d1Food_LastFirst. Correct the problem in the table that is allowing this type of error. Run the append query to ensure that duplicate records are no longer getting added to Customer Owners. Ensure that no duplicate records remain in the Customer Owners table. Close the database and exit Access. Based on your instructor's directions, submit a06d1Food_LastFirst