Querying Multiple Tables

A fundamental reason to build queries is to join together more than one table. There are several reasons that you might want to do that. The next two sections describe two typical reasons that were discussed briefly, and solely in the context of Excel, in Chapter 1, “Misusing Excel as a Database Management System.”


You direct the facilities department at Ballou Realty. Ballou leases space in its several buildings to other companies in need of office space. Your staff has built several databases to help maintain information on the offices themselves, on building equipment such as air conditioners and PBXs, and on building components such as windows and doors.

One of your databases contains records that describe ...

Get Managing Data with Microsoft® Excel now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.