Selecting Data from Multiple Tables
At this point, you’ve been through all the variations on a single theme—queries on a single table. It’s easy to build on this knowledge to retrieve related information from many tables and to place that information in a single view. You’ll find this ability to select data from multiple tables very useful in designing forms and reports.
Note
The examples in this chapter are based on the tables and data in HousingDataCopy.accdb and ContactsDataCopy.accdb on the companion CD included with this book. These databases are copies of the data from the Housing Reservations and Conrad Systems Contacts sample applications, ...
Get Microsoft Office® Access 2007 Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
