In Access, which of the following is a valid way to create a relationship between two tables? MCQ with Answer and Explanation

In Access, which of the following is a valid way to create a relationship between two tables?
A. Create a query that joins them
B. Both A and B
C. Drag the primary key field from one table to the foreign key field in another
D. Use the Relationships window
Answer: Option B
Solution (By JKSSB Mock Tests)
You can create relationships by dragging fields in the Relationships window, or use the Relationships window to add tables and define relationships. Queries join tables but don't enforce relationships.

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1
What is the shortcut to open a new blank document in MS Word?
A. Ctrl + S
B. Ctrl + O
C. Ctrl + N
D. Ctrl + Alt + N

Correct Answer: Option C


Explanation:
Ctrl+N new document.

This question belongs to: Computer Microsoft Office
Question #2
In Excel, which function is used to find the remainder after division?
A. QUOTIENT
B. DIV
C. REMAINDER
D. MOD

Correct Answer: Option D


Explanation:
MOD returns the remainder of a division. QUOTIENT returns the integer portion.

This question belongs to: Computer Microsoft Office
Question #3
In Excel, the formula =$A1 is an example of:
A. Mixed reference (column absolute, row relative)
B. Circular reference
C. Absolute reference
D. Relative reference

Correct Answer: Option A


Explanation:
$A locks column A, row remains relative.

This question belongs to: Computer Microsoft Office