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...
According to the ISO 12207 standard, what should be done to ensure that an organization understands the strengths and weaknesses of a lifecycle model?
Fill in the blank(s) with the appropriate word(s).
Under what circumstances might you choose to limit the number of waiting readers you would initiate when reading is allowed?
What will be an ideal response?
A lookup field is another name for a Lookup data type
Indicate whether the statement is true or false
In ____________________, you can see what a document will look like on the printed page before it is printed.
Fill in the blank(s) with the appropriate word(s).