Access Video Quiz X2.3
By Richard Rost
2 days ago
When Should You Use Cascade Delete Related Records What does cascade update related fields do in a relationship? Welcome to another Microsoft Access Video Quiz. You will be asked five expert-level questions about Access relationships, including cascade updates, cascade deletes, deleting related tables, the Relationships window layout, and configuring a custom subdatasheet query. Answer each question, check your score, and see how well you know Microsoft Access relationships. Recommended CoursesWant More?Keywords Access Video Quiz, cascade update related fields, cascade delete related records, referential integrity, foreign key updates, delete table relationship, Relationships window, remove relationship, subdatasheet name, master and child fields, custom query subdatasheet, order detail relationship
More InformationTranscript Welcome to another video quiz from Access Learning Zone. This one's for expert-level users.
You'll get five questions on Access relationships. You're gonna get three seconds to answer each one, so hit that pause button if you need more time. Keep track of your score so we know I did it at the end.
Are you ready to keep the Holodeck safety protocols online? Here we go.
Question one: What does cascade update related fields do in a relationship?
Updates every field in the related table.
Updates matching foreign key values when the parent key changes.
Creates a new child record whenever a parent changes.
Or changes AutoNumber values into short text.
That is, updates matching foreign key values when the parent key changes. I almost never use cascade update, but it's handy once in a while.
Question two: Which relationship is usually the best candidate for cascade delete related records?
Customer T to Order T, so accounting history disappears with the customer.
Employee T to Payroll T, so payroll history is erased when an employee leaves.
Order T to Order Detail T, so an abandoned order removes its line items.
Or Customer T to Contact T because every related table should always cascade delete.
That's gonna be Order T to Order Detail T, so an abandoned order removes its line items. All the other ones, you wanna keep that data.
Question three: What must happen before you can delete a table that participates in a saved Access relationship?
The relationship must be removed first, either manually or through Access's prompt.
The table's primary key must be changed to an AutoNumber.
Every query that uses the table must be converted to a report.
Referential integrity must be turned on for every other table.
That's gonna be A: the relationship must be removed first.
Question four: In the Relationships window, what happens if you remove a table box from the layout without deleting its relationship line?
The underlying table is deleted from the database.
Referential integrity is automatically disabled.
All related child records become orphaned.
Or the table is only hidden from that window; the relationship still exists.
Think of it more like a Relationships layout window.
And question five: Customer T has related Contact T and Order T records. You want its Datasheet view to show a custom query containing only selected contact fields as the subdatasheet. What should you configure?
Set Customer T's subdatasheet name to the custom query and specify the master and child fields.
Change Customer T's primary key to match the query name.
Turn on cascade delete related records for Contact T.
Create an AutoNumber field in the custom query.
That is gonna be: Set Customer T's subdatasheet name to the custom query and specify the master and child fields.
All right, how'd you do? Did you get all five right? Did you design a galaxy where even the safety protocol is applaud? Or did you materialize a beach ball during sword practice?
Well, if you missed any, these topics and a lot more are covered in Access Expert Level Two, Lesson Three, all about cascade update and delete.
Thanks for playing. Post your score in the comments below. Hopefully, none of your relationships caused a warp core-level cascade failure.
Until next time, live long and prosper. Intro What does cascade update related fields do in a relationship? Welcome to another Microsoft Access Video Quiz. You will be asked five expert-level questions about Access relationships, including cascade updates, cascade deletes, deleting related tables, the Relationships window layout, and configuring a custom subdatasheet query. Answer each question, check your score, and see how well you know Microsoft Access relationships. |
