Question

If you choose the ____, Access permits the change in value to the primary key and changes the appropriate foreign key values in the related table, thereby eliminating the possibility of inconsistent data in Yuka's database.

1) Cascade Update
2) Cascade Delete
3) Cascade Insert
4) Cascade Modify

Answer 1

The option in Microsoft Access that allows for consistent data in related tables is Cascade Update.

Step-by-step explanation:

In Microsoft Access, the option to ensure data consistency in Yuka's database is called Cascade Update. When this option is selected, any changes made to the primary key in one table will automatically update the corresponding foreign key values in related tables. This helps maintain data integrity and prevents inconsistent data.