Querying Multiple Related Tables

One of the most powerful things a query can do is pull matching information from several related tables at once, displayed together as though they'd always been one combined table. Add every table you need to the Show Table dialog; if a relationship already exists between them, Access automatically draws a connecting join line between the matching fields. Add fields from either table into the design grid exactly as before, and run the query to see combined results, correctly matched row by row.