Click the File menu and select “Save As” or “Save & Publish”. Click “Backup Database” in the Advanced section. Follow the prompts to backup your database.
Set your database to Exclusive mode if you can. This will prevent any changes from being made by other users. Click the File menu and select “Options”, then select “Client Settings”. In the “Default open mode” section, select “Exclusive”. If you don’t have many people using the database, you generally don’t need to worry about this.
2013/2010 - Click the “Create” tab and then click “Query Wizard”. 2007 - Click the “Insert” or “Create” tab and select “Query Wizard”. 2003 - Open the Database window and select the “Queries” tab. Click the “New” button.
For most duplicate checking, you’ll want to keep the “Tables” view selected.
Avoid using general fields. Avoid using fields like the date or location to reduce clutter when comparing entries. Without enough fields to make a distinction between records, or with fields that are too general, you’ll get a lot of duplicate results.
If you can’t decide, recreate the query with an additional field to help you make your decision.
You may want to merge some data from one of the duplicate records into the record you plan to keep. Make sure to not delete all of the records that appear on the duplicate result list, or you won’t have an original record left.
