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

Keys

Each table in your database represents one subject only. But as you've seen, to accomplish your mission objectives, you need data from two, three, or even more of these tables. For example, the invoice you looked at earlier requires values from the Customers, Orders, and Order Details tables, and perhaps other tables as well. Having segregated your data by subject, how do you now tie together these tables so you can combine their values and accomplish your mission objectives?

Keys are a vital part of the answer. Keys are essential for ensuring that each record in a table is uniquely identified. You'll soon see that achieving that objective is crucial if you hope to bring together data from several tables while maintaining data integrity. ...

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