Access 2010 In Pictures
Remove duplicates

1 When the alert window appears, click the Yes button.

The query results should now look like this:

Record number 7 is removed from the database.

TIP: Deleting a record from a query also deletes it from the table it was stored in.

2 Close the window.

3 Open the Customers table.

It should now look like this, with only one record for Jane Doe:

4 Close the Customers table.