FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
What is the advantage of reports over queries?
A
Reports can be formatted
B
Reports can access more data
C
Queries can be formatted
D
None of the above
Explanation: 

Detailed explanation-1: -A query is a question you define and send to the data source to retrieve the data. A report is an organized and formatted view of the data the query retrieved. The report does not have to include all of the data items you specify in the query.

Detailed explanation-2: -Queries help you find and work with your data A query can either be a request for data results from your database or for action on the data, or for both. A query can give you an answer to a simple question, perform calculations, combine data from different tables, add, change, or delete data from a database.

Detailed explanation-3: -Query-a question, especially one expressing doubt or requesting information is called Query. Form-a way in which a thing appears is called Form. Reports-a piece of information that is unsupported by firm evidence is called Reports.

Detailed explanation-4: -Queries to find and retrieve just the data that you want. Forms to view, add, and update data in tables. Reports to analyze or print data in a specific layout.

There is 1 question to complete.