Microsoft Office Tutorials and References
In Depth Information
In the Navigation Pane, Access displays objects alphabetically by object type with tables
appearing first and then queries, forms, and reports. Access displays some types of queries
separately from select queries; for example, crosstab queries appear before select queries.
Access uses unique icons to represent different types of queries. The crosstab query icon
appears in the Queries list to the left of the qryCustomersAndInvoicesCrosstab query. This
icon looks different from the icon that appears to the left of the other queries, which are all
Next, Oren wants to identify any contracts that have the same start dates as other con-
tracts, because these are the ones that might have potential scheduling difficulties. To
find the information Oren needs, you’ll create a find duplicates query.
If you point to an object in
the Navigation Pane, a
ScreenTip displays the full
Creating a Find Duplicates Query
A find duplicates query is a select query that finds duplicate records in a table or query.
You can create this type of query using the Find Duplicates Query Wizard . A find dupli-
cates query searches for duplicate values based on the fields you select as you answer
the Wizard’s questions. For example, you might want to display all employers that have the
same name, all students who have the same phone number, or all products that have
the same description. Using this type of query, you can locate duplicates to avert potential
problems (for example, you might have inadvertently assigned two different numbers to the
same product), or you can eliminate duplicates that cost money (for example, you could
send just one advertising brochure to all customers having the same address).
You can meet Oren’s request by using the Find Duplicates Query Wizard to display
records for contracts that have the same start dates in the tblContract table.
Reference Window | Using the Find Duplicates Query Wizard
• In the Other group on the Create tab, click the Query Wizard button.
• Click Find Duplicates Query Wizard, and then click the OK button.
• Complete the Wizard dialog boxes to select the table or query on which to base the query,
select the field (or fields) to check for duplicate values, select the additional fields to include
in the query results, enter a name for the query, and then click the Finish button.
You’ll use the Find Duplicates Query Wizard to create and run a new query to display
duplicate start dates in the tblContract table.
To create the query using the Find Duplicates Query Wizard:
1. Close the Navigation Pane, click the Create tab on the Ribbon and then, in the
Other group on the Create tab, click the Query Wizard button to open the New
Query dialog box.
2. Click Find Duplicates Query Wizard , and then click the OK button. The first Find
Duplicates Query Wizard dialog box opens. In this dialog box, you select the table
or query on which to base the new query. You’ll use the tblContract table.
3. Click Table: tblContract (if necessary), and then click the Next button. Access
opens the next Find Duplicates Query Wizard dialog box, in which you choose the
fields you want to check for duplicate values.