Business Solutions Microsoft® Office Access 2007 Forms, Reports, and Queries

12. Working with Multiple-Table Queries

IN THIS CHAPTER

Relational Database Fundamentals

Types of Relational Models

Enforcing Referential Integrity

Establishing Table Relationships

Working with Multiple Tables in a Query

Creating Other Types of Joins

Creating a Unique Values Query

Case Study: Drilling Down to the Order Details

From Here

Most database applications (and all well-designed database applications) store their information in multiple tables. Although most of these tables have nothing to do with each other (for example, tables of customer information and employee payroll data), it’s likely that at least some of the tables do contain related information (such as tables of customer information and customer orders).

Working with multiple, ...