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

Query

The correct answer is Option (2) - Query.

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

The Queries provide the real power to a database in terms of its capabilities to answer more complex requests (or queries). In case of Access, Queries provide the capability of combining data from multiple tables and placing specific conditions for the retrieval of data. In its simplest form, you may consider a Query to be another tabular view of your data showing information from one or more tables.