Explain why you would you use the Cascade Update option when setting a relationship.
What will be an ideal response?
You would use the Cascade Update Related Fields option so that when the primary key value is modified in a primary table, Access will automatically update all foreign key values in a related table. For example, if you change a CustomerID value in a Customers table, it will automatically update to his/her related accounts or orders or any other related table.
You might also like to view...
What is the effect of changing the date the password was last changed to zero?
A. It disables the account. B. It forces the user to change the password at the next login. C. It sets the password to never expire. D. It sets the password to expire in 24 hours.
The ________ provides access to common functions via drop-down lists
A) Standard Toolbar B) Formatting Toolbar C) Menu Bar D) Title Bar
In the accompanying figure, Item 2 points to the ____.
A. Font Size pop-up menu arrow B. Text Effects pop-up menu arrow C. Text Highlight Color pop-up menu arrow D. Font Color pop-up menu arrow
The accompanying figure displays the ____ tab on the Delicious home page.
A. Popular Bookmarks B. Fresh Bookmarks C. Popular Tags D. Explore Tags