How to Create a Parameter Query in Microsoft Access

Save
Next Video:
How to Create a Query From a Filter in Microsoft Access....5

In Microsoft Access, creating a parameter query requires access to the query design tool, which can be reached by clicking on the "Create" tab. Discover how adding a parameter to a field is similar to a criteria with help from a computer programming teacher in this free video on Microsoft Access.

Part of the Video Series: Microsoft Access Tutorial
Promoted By Zergnet

Comments

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.

Featured

Related Searches

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!