Parameter are flexible queries that allow the end user to enter a search term after running the query.
Step 1: Click the Create tab then click query wizard.
Step 2: Select the fields you would like to use in your query. Tip- you can select fields from multiple tables from the drop down list for Tables/Queries before you move to the next step in the wizard.
Step 3: In the summary options, choose detail if you want to show every field of every record or click summary for summary options like sum, average, and count functions.
Step 4: Name the query on the last step of the query wizard and click finish.
Step 5: Navigate to the design view of the query. On the criteria line below the field you want to search, type inside of square brackets a prompt for the end-user. NOTE- The prompt can’t be the same as your field name.
Now that the parameter query is set up, run it and you will get a box that states “Enter Parameter Value” on the title and also displays the prompt typed inside of square brackets.
Enter the search term, click OK, and view the results.
This parameter value returns the following results.