O'Reilly logo

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

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

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

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