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

Referential Integrity

In an ancient Microsoft Access book whose author was apparently addicted to TV, there is a listing in the index for something called “residential integrity.” So it might be worthwhile to emphasize that the term I'm about to discuss is referential integrity and that it has nothing to do with property maintenance or neighborhood beautification.

Referential Integrity at Work

The Access Help definition of referential integrity is “a system of rules that Microsoft Access uses to ensure that relationships between records in related tables are valid, and that you don't accidentally delete or change related data.” That's a start. But the best way to understand referential integrity is to see it at work, which I hope the following ...

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