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. Both A and B
B. Create a query that joins them
C. Use the Relationships window
D. Drag the primary key field from one table to the foreign key field in another
Answer: Option A
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
In MS Access, which view is used to design the structure of a table (field names, data types)?
A. Design View
B. Layout View
C. Form View
D. Datasheet View

Correct Answer: Option A


Explanation:
Design View is used to define field properties. Datasheet View shows data in rows/columns.

This question belongs to: Computer Microsoft Office
Question #2
In Excel, the 'Go To Special' dialog can be opened by:
A. Alt + F5
B. Ctrl + G
C. F5 -> Special button, or Home tab -> Find & Select -> Go To Special
D. Ctrl + Shift + G

Correct Answer: Option C


Explanation:
F5 opens Go To, then click Special. Alternatively, Home > Find & Select > Go To Special.

This question belongs to: Computer Microsoft Office
Question #3
What is the function of 'Ctrl + Page Up' in MS Word?
A. Insert page break
B. Move to the top of the previous page
C. Scroll up
D. Move to previous section

Correct Answer: Option B


Explanation:
Ctrl+Page Up goes to previous page top.

This question belongs to: Computer Microsoft Office