• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 5. Using Microsoft Query > Querying Multiple Tables

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

CASE STUDY

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.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint