Microsoft Office Tutorials and References
In Depth Information
Querying a Database
Creating an unmatched query
Access can store huge amounts of data, but the more data you store, the
harder it can be to view your data. To help you organize your data, you can
divide data into separate tables. One table may contain a list of customers,
and a second table may contain a list of salespeople.
When you store data in separate tables, each table may share one or more
common fields. For example, a table containing customers may contain a
SalesPerson field that shows which salesperson deals exclusively with which
customer. A second table listing salespeople could contain the Customer
field (along with additional information such as each salesperson’s phone
number, address, sales region, and so on).
An unmatched query examines two (or more) database tables to look for
missing information. For example, you could also use an unmatched query to
find customers who haven’t ordered anything in the past six months, sales
regions that haven’t ordered certain products, or salespeople who have not
been assigned to a sales region. Basically, an unmatched query can help you
find missing pieces or holes in your entire database file.
To create an unmatched query, follow these steps:
1. Click the Create tab.
2. Click the Query Wizard icon in the Other group.
The New Query dialog box appears (refer to Figure 17-8).
3. Click Find Unmatched Query Wizard and then click OK.
The Find Unmatched Query Wizard dialog box appears, asking you to
choose a database table that contains the unmatched records you want
4. Click a database table and then click Next.
Another dialog box appears, asking you to choose a database table that
contains at least one field that also appears in the table you chose in
5. Click a second database table and then click Next.
Another dialog box appears, asking you to identify the field that both
database tables have in common.
6. Click the common field that both database tables share.
7. Click on the gray <=> button that appears between the two fields and
then click Next.