Microsoft Access Relationships and Referential Integrity Quiz

Test your Microsoft Access relationship skills with five expert-level questions about parent and child tables, one-to-many relationships, subdatasheets, orphaned records, and referential integrity. Find out what happens when you try to delete a customer who still has related contacts, why Access blocks deletions in a properly enforced relationship, and when cascade deletes can change the outcome. It is a useful refresher for avoiding broken customer and contact records. The quiz also covers the database setup Access needs before it can enforce referential integrity, including compatible field data types and a unique parent key. See whether your relationships are protected or wandering around without parents.