Help users increase productivity by automatically signing up for TechRepublic’s free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.
When working with tables in Access, you often have to refer
to data in various tables—even if the tables aren’t related. The good news is that it’s simple to create a select query to find records in one table that don’t
have related records in another table.
For example, suppose your database contains a table named
Computers 101-Registered Students, which lists the students who have registered
for a Computer course. Your database also has a second table named Computers
101-Attendance, which lists the students who are currently attending the
course. Let’s say that you want to find out if any students attending the
course have not yet registered.
Follow these steps to set up a query that will answer your
Queries under Objects in the Database Window.
- Go to
New | Find Unmatched Query Wizard and then click OK.
Computer 101-Attendance and then select Computer 101-Registered.
the matching field, for example, Student ID.
the student first_name and last_name
fields and click Finish.
The results will list the names of the students who are
listed as attending the course but have no record of being registered.