A quick and easy to follow video tutorial example of how to create a parameter query which reduces the number of stored (repetitive) queries in your database.

A parameter prompts you for a value and passes it into your query during the run-time (execution) of the query which makes it a more flexible query as it is now a variable value which is passed and not a fixed value within the design of the query (SQL statement).

This can then serve your forms and reports which in turn triggers the prompt. You can have more than one parameter too to make extra flexible and it applies to all versions of Microsoft Access (not just 2007)!

Tags: Access 2007, access parameter queries, building access parameter queries, create a parameter query, how to create a parameter query, microsoft access parameter query