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, ContactsDataCopy.accdb, and BOSSDataCopy.accdb on the companion CD included with this book. These databases are copies of the data from the Housing Reservations, Conrad Systems Contacts, and Back Office Software System sample applications, respectively, and they contain the sample queries ...
Get Microsoft® Access® 2010 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.
