Cascade update option in Access

means do not change the value in the primary key field if that record has related records in another table

means change all the related records in child tables if the record in parent table is changed

Both of above

None of above

Correct answer is C

The Cascade update option in the context of database relationships refers to the behavior that occurs when you modify a record in the parent (or primary) table. Both of the provided options are accurate descriptions of the cascade update option:

Option A: When you enable the cascade update option, it means that if you change the value in the primary key field of a record in the parent table, the related records in the child tables will also be updated to reflect the changes in the parent table. This ensures that the relationships between records remain consistent even when the primary key values change.
Option B: Similarly, enabling the cascade update option will change all the related records in child tables when the record in the parent table is changed. This ensures that any changes made to the parent table's primary key values are propagated to the related child records.
Option C: Both of the above options are true. Enabling cascade update means that changes to primary key values are propagated to related records in child tables, and this applies to both the parent and child records.
Option D: Neither option A nor option B is false. Therefore, the correct answer is Option C: Both of above.

In summary, the cascade update option maintains data integrity by ensuring that changes to primary key values in the parent table are reflected in the related records of the child tables.