In MS Access, what is a 'Relationship'? MCQ with Answer and Explanation

In MS Access, what is a 'Relationship'?
A. A connection between two tables based on a common field
B. A connection between a query and a form
C. A connection between two databases
D. A link between a table and a report
Answer: Option A
Solution (By JKSSB Mock Tests)
A relationship in Access is an association between two tables that uses a common field to link data. It can also be between queries, but primarily tables.

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1
In Excel, which function is used to calculate the arithmetic mean of a set of numbers?
A. MEDIAN
B. AVERAGE
C. AVERAGEA
D. MODE

Correct Answer: Option B


Explanation:
AVERAGE is the arithmetic mean. AVERAGEA includes logical values, MEDIAN is middle value, MODE is most frequent.

This question belongs to: Computer Microsoft Office
Question #2
In MS Access, what type of structural relationship is formed between two tables when a unique primary key is linked to a field that is also a primary key in another table?
A. One-to-One
B. One-to-Many
C. Many-to-Many
D. Self-Referential

Correct Answer: Option A


Explanation:
When both linked fields in a database relationship are primary keys or unique indexes, a One-to-One relationship is generated.

This question belongs to: Computer Microsoft Office
Question #3
What is the shortcut key to insert a new slide in MS PowerPoint?
A. Ctrl + M
B. Ctrl + N
C. Ctrl + D
D. Ctrl + Shift + N

Correct Answer: Option A


Explanation:
Ctrl+M inserts a new slide. Ctrl+N creates a new presentation. Ctrl+D duplicates slide.

This question belongs to: Computer Microsoft Office