An Access parameter query, is a query that is simple and can be the most effective query you can create. Because these parameter queries are simple data can be updated easily to reflect a new search term.
What To Do and What Not To Do with Parameter Queries
When the parameter query is being designed make sure that the prompt is not the same as one of the field names. For example, if you use this for the parameter [LastName] to prompt a user to enter a name into the LastName Field, it will not work. This is because Access uses the square brackets for the field names to process the calculations in queries. A way around this is to add a question mark [LastName?].