ECDL Exam ECDL-ADVANCED Topic 5 Question 62 Discussion

Actual exam question for ECDL's ECDL-ADVANCED exam

Question #: 62
Topic #: 5

Which of the following queries prompts a user for information to be used in the query?

ASelect

BParameter

CAction

DUnmatched
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 A is incorrect. A select query is used to retrieve data from one or more tables. It is used to display the results in a datasheet.
Answer option D is incorrect. An unmatched query is a form of select query that locates records in one table that does not have related records in another table. For example, a user can use this to locate people in the customer table who do not have an order in the order table. The Find Unmatched Query wizard guides the user through the process of specifying the tables and fields to use in the query.
Answer option C is incorrect. An action query is used to update multiple records in one operation.

Show Suggested Answer

Suggested Answer: B

Chapter: DATABASE, ADVANCED-LEVEL

Objective: Table Design

by Bernardo at Dec 10, 2022, 07:29 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!