Stan is creating a query that provides employee information. He wants the query to first ask users to enter a department name and then display records only for employees in that department. What type of query should he create?
A) Top Values query
B) Crosstab query
C) Parameter query
D) Find Unmatched query

Question

Quizplus · Accepted Answer

Stan should create a parameter query, which allows users to input a specific value (in this case, a department name) that is used to filter the records displayed in the query. This is the most appropriate type of query for Stan's needs, as it allows for user input and filters the results based on that input.

Stan Is Creating a Query That Provides Employee Information