Examveda

Queries in Access can be used as

A. view, change and analyze data in different ways

B. a source of records for forms and reports

C. Only A

D. Both A and B

Answer: Option D

Solution (By Examveda Team)

In Microsoft Access, queries serve multiple purposes, as described in the options:

Option A: Queries can be used to view, change, and analyze data in different ways. You can create queries that extract specific data based on criteria you define, sort and filter data, perform calculations, and join data from multiple tables. Queries help you retrieve and present data in a way that meets your requirements.
Option B: Queries can also be used as a source of records for forms and reports. Forms and reports are designed to provide user-friendly interfaces for data entry and presentation, respectively. Queries allow you to extract the necessary data from tables and present it in forms for data entry or in reports for printing and analysis.
Option C: This option seems incomplete, but from the context, it's not accurate. Queries can serve more than just one purpose.
Option D: Both options a and b are accurate. Queries can be used to view, change, analyze data and also serve as sources of records for forms and reports.

Therefore, the correct option is Option D: Both A and B. Queries in Microsoft Access are versatile tools that offer both data manipulation and data presentation capabilities.

This Question Belongs to Computer Fundamentals >> MS Access

Join The Discussion

Related Questions on MS Access