It is a query that when run displays its own dialog box prompting you for information, such as A. Select B. crosstab C. Parameter D. Append

Select
crosstab
Parameter
Append

The correct answer is C. Parameter.

A parameter query is a query that when run displays its own dialog box prompting you for information, such as the name of a table or the value of a field. This information is then used to filter the results of the query.

A select query is a query that selects data from one or more tables.

A crosstab query is a query that summarizes data in a tabular format.

An append query is a query that adds data from one table to another table.

Here is an example of a parameter query:

SELECT *
FROM Customers
WHERE CustomerID = [Enter Customer ID]

When this query is run, a dialog box will appear prompting you for the Customer ID. You can then enter the Customer ID and click OK to run the query.

The results of the query will show all of the records for the Customer ID that you entered.

Exit mobile version