Microsoft Office Tutorials and References
In Depth Information
Finding Duplicate Records
you can decide later whether to delete them. Perhaps looking at repeated
addresses is a good start. If you do mass mailings, you may be sending two
or more of every item to the customers whose records are duplicated.
Before you go looking for duplicate records, think about which combination
of fields in your table will indicate records that are likely duplicates; then
use the Find Duplicates Query Wizard to locate those records. Because the
Find Duplicate Query Wizard finds only duplicates, you can use your
judgment to decide whether to delete records that look like duplicates. Follow
these steps to run the wizard:
1. Click the Query Wizard button in the Queries group on the Create tab
of the Ribbon.
The New Query dialog box opens.
2. Select the Find Duplicates Query Wizard option and then click OK.
The Find Duplicates Query Wizard starts.
3. Click the name of the table that you want to search in the first window
of the wizard and then click Next.
Optionally, you can click the Queries option and choose a query to use
as the basis for the search.
4. Click the > button to copy fields from the Available Fields list to the
Duplicate-Value Fields list in the second window of the wizard and
then click Next.
Be sure to include all fields that contain the data needed to define
duplicate records. The query in Figure 3-12, for example, is about to
find records that have identical information in the First Name and
Address 1 fields.
of the Find