ECDL Exam ECDL-ADVANCED Topic 7 Question 25 Discussion

Actual exam question for ECDL's ECDL-ADVANCED exam

Question #: 25
Topic #: 7

Which of the following types of query is commonly useful when queries are used as the basis for a report that is run periodically, but with different values at different times?

ACrosstab query

BAction query

CSelect query

DParameter query
Explanation:
A parameter query prompts a user for information to be used in the query. For example, a range of dates. This type of query is commonly useful when queries are used as the basis for a report that is run periodically, but with different values at different times.
Answer option C is incorrect. A select query is a simple type of query that is commonly used in Microsoft Office Access 2007. This query retrieves data from one or more tables and displays the results in a datasheet. A user can use a select query to group records and calculate sum, counts, averages, and other types of totals. The user can also work with the results of a select query in the Datasheet view to update records in one or more related tables at the same time.
Answer option B is incorrect. An action query is used to update multiple records in one operation. It is a form of select query that performs an action on the results of the selection process. There are four types of action queries available in Microsoft Office Access 2007, which are as follows:
Delete queries: A delete query allows to delete records from one or more tables.
Update queries: An update query allows to modify fields. This is used to update a field with an expression or data from another table.
Append queries: An append query allows to add records from one or more tables to the end of one or more other tables.
Make-table queries: A make-table query allows to create a new table from all or part of the data in one or more tables.
Answer option A is incorrect. A crosstab query is a powerful analysis tool used to see the relationship of data between two fields. It calculates and restructures data for easier analysis. A user can use a crosstab query to calculate a sum, average, count, or other type of total for data that is grouped by two types of information- one down the left side of the datasheet and one across the top. The cell at the junction of each row and column displays the results of the query's calculation. This view is just like a spreadsheet with unique values of one field as rows, unique values of another field as columns, and the summary of another field as the cells in the matrix.

Show Suggested Answer

Suggested Answer: D

Chapter: DATABASE, ADVANCED-LEVEL

Objective: Query Design

by Fletcher at May 05, 2022, 02:42 AM

Limited Time Offer

25%

Off

Get Premium ECDL-ADVANCED Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!