O'Reilly logo

Microsoft® Access® 2010 Inside Out by Jeff Conrad and John Viescas

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required