How to Create a Parameter Query in Microsoft Access

Video Transcript

"Hi my name is Chip Browne. I teach computer programming and Microsoft Application classes at a local business college here in Utah at Stevens Henagar Business College. I also create practice tests for Microsoft Office Application Specialists Certifications. Today we're going to learn in Microsoft Office Access 2007 how to create a parameter query in Microsoft Access. Microsoft Access is a registered trademark of Microsoft Corporation. I am not affiliated with Microsoft Access. To create a query that has a parameter we need to first go into Query Design Tool. To access the Query Design Tool click on the create tab. Next under the other group click on Query Design. Choose either a table or a query. Add fields to your query. Click, shift click, and drag. To add a parameter to a field it is very similar to a criteria. In the criteria field of a particular field of the query you add the text that you want displayed in a prompt and you put a left bracket and right bracket around that text. For example in the criteria field I have put enter order ID surrounded by left and right brackets. That's the message that is going to be prompted when we run the query. Now we enter in the value and click OK. Here is a result of running the query after we entered in 31 for the order ID. It returns a subset as if we had put 31 in the criteria field. This is how you create a query with a parameter. For more information and videos visit me, Chip Browe, at chipbrowne.com."