In MS Access, which join type in a Query design screen extracts all records from Table A and only those records from Table B that have matching key values? MCQ with Answer and Explanation
Question
Report Error
Discuss this Question (0)
Practice More Microsoft Office Questions
Question #1
Report Error
What is the keyboard shortcut to left-align a selected block of text characters or an active paragraph in MS Word?
Correct Answer: Option B
Explanation:
Ctrl + L is the standard keyboard shortcut used to apply left alignment to selected text or paragraphs in MS Word.
Ctrl + L is the standard keyboard shortcut used to apply left alignment to selected text or paragraphs in MS Word.
This question belongs to:
Computer
Microsoft Office
Question #2
Report Error
What is the purpose of the PMT function in Excel?
Correct Answer: Option C
Explanation:
PMT(rate, nper, pv) computes loan payment. FV returns future value, PV present value.
PMT(rate, nper, pv) computes loan payment. FV returns future value, PV present value.
This question belongs to:
Computer
Microsoft Office
Question #3
Report Error
In MS Access, a relationship between two tables that requires a third junction table is called:
Correct Answer: Option D
Explanation:
Many-to-many relationships need a junction table with foreign keys to both primary tables.
Many-to-many relationships need a junction table with foreign keys to both primary tables.
This question belongs to:
Computer
Microsoft Office
No comments yet. Be the first to start the discussion!