In MS Access, what is the purpose of the 'Relationship' window? MCQ with Answer and Explanation

Question

Share Report Error

In MS Access, what is the purpose of the 'Relationship' window?

A. Design queries

B. Define connections between tables and enforce referential integrity

C. Set user permissions

D. Create forms

Answer: Option B

Solution (By JKSSB Mock Tests)

Relationships window links tables.

This question belongs to: Computer Microsoft Office

Request complete Subject PDF

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1

In Excel, what does the 'COLUMN' function return?

A. The number of columns in a range

B. The column number of a reference

C. The letter of the column

D. The column header

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
COLUMN returns the column number (e.g., 1 for column A). It does not return letters or counts of columns.

This question belongs to: Computer Microsoft Office

Question #2

In MS Access, what is the purpose of the 'Compact and Repair' database utility?

A. Creates a backup

B. Splits the database into front-end and back-end

C. Reduces file size and fixes corruption

D. Encrypts the database

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Compact and Repair reclaims unused space and repairs minor issues.

This question belongs to: Computer Microsoft Office

Question #3

To insert a row above the selected row in Excel, press:

A. Alt + I, R

B. Ctrl + Shift + + (plus)

C. Ctrl + +

D. All of these

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
All these shortcuts can insert a row when a row is selected.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs