What is a 'parameter query' used for in Access?

A parameter query in Access is specifically designed to allow users to input criteria at runtime, making it a dynamic tool for data retrieval. When users run a parameter query, they are prompted to enter specific values that the query will then use to filter records from the database. This flexibility is beneficial because it enables users to specify their search criteria each time they run the query, thus tailoring the results according to their needs without requiring any changes to the underlying query structure.

This dynamic aspect of parameter queries sets them apart from static queries, where the criteria are predetermined and do not require user input. Consequently, a parameter query can adapt to various needs and situations, enhancing the overall usability of the database for end users.