Which of the following is used for extraction from one or more tables in a database that can be used as the basis of a report or as a standalone information source?

Which of the following is used for extraction from one or more tables in a database that can be used as the basis of a report or as a standalone information source?
A . Query
B . Form
C . Pivot Table
D . Reference Table

Answer: A

Explanation:

A query is used for extraction from one or more tables in a database that can be used as the basis of a report or as a standalone information source. It is a request for information from a database. Answer option D is incorrect. A reference table is a set of references that an author may have cited or gained inspiration. It is an information table that is used as a quick and easy reference for things that are difficult to remember such as comparing imperial with metric measurements.

Answer option B is incorrect. A Form is a collection of one or more fields that allow the user to enter information (like text fields, text area fields, drop-down menus, radio buttons, check-boxes, etc.).

Answer option C is incorrect. PivotTable is a view of a table, which can be used to display the data of a table in the desired format. This view cannot be used to create or delete a field or modify its properties. The data can be filtered according to fields. When the PivotTable view is opened, a blank work area is displayed and the columns of the table are displayed in the Pivot Table Field List window.

Chapter: ADVANCED SPREADSHEETS

Objective: Special Tools