In MS Access, the 'Cascade Update Related Fields' option will: MCQ with Answer and Explanation

In MS Access, the 'Cascade Update Related Fields' option will:
A. Copy the primary key to child table
B. Automatically update the foreign key in related records when the primary key is changed
C. Prevent deletion of records that have related records
D. Delete related records when the primary record is deleted
Answer: Option B
Solution (By JKExamLibrary)
Cascade Update updates foreign keys. Cascade Delete deletes related records.

This question belongs to: Computer Microsoft Office

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Microsoft Office Questions

Question #1 Report Error
In Access, which of the following is used to create a calculated field in a query?
A. Design View only
B. Field row with a calculated expression
C. Both A and B
D. Expression Builder

Correct Answer: Option C


Explanation:
You can create calculated fields by typing an expression in the Field row of the query design grid, or using the Expression Builder. Both are valid.

This question belongs to: Computer Microsoft Office
Question #2 Report Error
What is the primary action performed by the shortcut key combination Ctrl + N when working inside MS PowerPoint?
A. Inserts a new slide into the active presentation file
B. Launches the speaker notes view window
C. Opens a brand-new, blank presentation file window
D. Minimizes the current display window

Correct Answer: Option C


Explanation:
In MS PowerPoint, Ctrl + N opens a brand-new, blank presentation file. To insert a new slide into the current file, the shortcut is Ctrl + M.

This question belongs to: Computer Microsoft Office
Question #3 Report Error
Which command tool in MS Excel removes duplicate rows from a selected data worksheet based on chosen columns?
A. Consolidate Data
B. Data Validation
C. Remove Duplicates
D. Text to Columns

Correct Answer: Option C


Explanation:
The 'Remove Duplicates' feature on the Data tab analyzes selected rows and permanently deletes duplicate entries.

This question belongs to: Computer Microsoft Office