Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
In Access 2010 Essential Training, Alicia Katz Pollock gives a comprehensive overview of creating databases in Access 2010, whether using predefined database templates or building from scratch. This course covers each step of constructing and modifying databases for custom purposes, as well as working with tables, forms, queries, macros, and reports and charts for record keeping and analysis. Exercise files are included with the course.
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.
Find answers to the most frequently asked questions about Access 2010 Essential Training.
Here are the FAQs that matched your search "":
Sorry, there are no matches for your search ""—to search again, type in another word or phrase and click search.
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.