Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills

Multitable Queries

Until now, all the queries you've done in this book have been based on one table. That's fine for learning some basics and a few features and techniques. But it isn't why you're using Access or why you bought this book. All the hard work of organizing data into tables and creating relationships starts to pay off when you create queries using more than one table.

As I've emphasized often, the way you organize data into tables has little to do with how you actually use that data. You organized your database for maximum efficiency and speed, without worrying about the final purposes to which its data will be put.

Specifically, you don't care that customer names are not in the Orders table, even though they're needed for the order ...