Accountancy Part ADatabase Management System for Accounting

In order to retrieve select data meeting a specified criteria from tw…

In order to retrieve select data meeting a specified criteria from two different tables of Access database, we may make use of:

Answer & explanation

Correct answer: option 2

The correct answer is Option (2) → Query

Note: This question is from the pre-rationalised NCERT book. The topic is not there in the latest NCERT book (2026-27), but it is still in the CUET 2026 syllabus, so do not skip it.

NCERT (Pre-rationalised edition):
Multiple Choice Questions – “… 12. In order to retrieve select data meeting a specified criteria from two different tables of Access database, we may make use of : a. Table b. Query c. Form d. Report.”

NCERT (Pre-rationalised edition):
Creation of Query in Microsoft Access – “… In its simplest form, you may consider a Query to be another tabular view of your data showing information from one or more tables.”