O'Reilly logo

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

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

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

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