Access Video Quiz X2.2

11 hours ago

Delete Customer With Related Contact Records?

What is an orphaned record in a one-to-many relationship? Welcome to another Microsoft Access Video Quiz. You will be asked five expert-level questions about table relationships, subdatasheets, orphaned records, referential integrity, and the requirements for enforcing relationships between tables. Answer each question, check your score, and see how well you know Microsoft Access.

Recommended Courses

Access Expert 2, Lesson 2

Want More?

Access Video Quizzes

Keywords

Access Video Quiz, Access table relationships, referential integrity, one-to-many relationship, orphaned records, explicit relationship, parent and child tables, cascade delete, relationship subdatasheet, compatible data types, unique parent key

Comments for Access Video Quiz X2.2

Age	Subject	From
11 hours	Post Your Quiz Score Here!	Richard Rost

More Information

Transcript

Welcome to another video quiz from Access Learning Zone.

This one is for expert-level users, and we got five questions covering table relationships. You'll have three seconds to answer each one, so hit that pause button if you need more time.

Keep track of your score so you can see how you did at the end. Are you ready? Here we go.

Question one: What is an explicit relationship in an Access database?

A relationship saved at the database level between tables, a calculated field that combines two tables, a relationship created only while a query is open, or a pinky promise between your records.

That's going to be a relationship saved at the database level between tables.

Question two: After creating a one-to-many relationship, where can Access display a subdatasheet of related child records?

Only in a report's page footer, on the parent table, the one side of the relationship, on the child table, the many side only, or inside every AutoNumber field.

That's going to be on the parent table, the one side of the relationship. You get those little plus buttons you can click on.

Question three: What is an orphaned record in a one-to-many relationship?

A parent record that has no children yet, a record with an AutoNumber primary key, a child record whose related parent no longer exists, or a record that has wandered away from the navigation pane.

That's going to be a child record whose related parent no longer exists. It's an orphan, as opposed to a widow, which is the other way.

Question four: With referential integrity enforced, what happens if you try to delete a customer who still has related contact records?

Access blocks the deletion until the related contacts are handled, Access silently changes each contact's customer ID to zero, Access automatically copies the contacts into Customer T, or Access deletes the entire database for dramatic effect.

That's going to be Access blocks the deletion until the related contacts are handled. Got to delete the contacts first before you can delete the customer. Unless you've got cascade deletes on, but that's dangerous, and that's a whole different thing.

Question five: Which setup is required before Access can enforce referential integrity between Customer T and Contact T?

Customer ID must be short text in both tables, the matching fields must have compatible data types and the parent key must be unique, Contact T must contain at least one contact for every customer, or both tables must be printed before creating the relationship.

That's going to be the matching fields must have compatible data types and the parent key must be unique.

All right, how'd you do? Did you get all five right? Did you retire the last replicant with a paper unicorn? Or is your hover car still in the rainy parking garage?

Well, if you missed any, these topics and a lot more are all covered in my Access Expert Level Two class, Lesson Two, which is about relationships and referential integrity.

Thanks for playing. Post your score in the comments and let us know whether your database relationships are properly enforced or just wandering around without parents.

Until next time, live long and prosper.

Intro