Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
Sometimes when you run a query, you would like run the same analysis but change the group that you're running it for. You don't have to create multiple queries. A Parameter Query will allow you to reuse one Generic Query. Let's build on the Maryland Orders Query we made in the previous lesson. Right-click on it and choose Copy. Then right-click in the white area at the bottom and choose Paste. Rename it Orders by State. Click OK.
Right-click on it and open it in Design View. In the State Criteria, erase MD and type in a square bracket, then type What State? And then close the bracket. What you're doing is entering in the question Access is going to ask you. So use real English. Click on the View button, and a dialog box will open asking you "What State?". Enter in NY for New York and click OK, and now you can see your orders for New York.
Right-click on the tab to close it, and if it asks you to Save, please do, and let's try it again. Double-click on Orders by State. It asks you What State? This time type in VA, for Virginia, and click OK. Now you've got your orders from Virginia. Parameter Queries allow you to use the same query over and over, just entering in the desired criteria every time.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 91389 Viewers
80 Video lessons · 138265 Viewers
59 Video lessons · 57095 Viewers
52 Video lessons · 70746 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.