What is the purpose of a parameter query? What happens when a parameter query is executed?
What will be an ideal response?
Parameter queries can be designed when you need to change the criteria for which you want to search. In this case, a variable parameter can be used. When a parameter query is run, the user is prompted to enter the value for each parameter or variable. Using parameters in queries is exceptionally powerful and converts static queries, where the criteria are already entered into the Design view, to flexible, dynamic queries that are customized to a user's needs. The use of parameters can significantly reduce the number of queries you need to create, make queries more useful, and simplify database maintenance.
You might also like to view...
By default, the text you type into a document replaces existing text
Indicate whether the statement is true or false
Background 1 is a code used by Access to represent the color:
A) blue. B) red. C) white. D) black.