- [Instructor] I'm a firm believer in teaching…database users how to run their own queries…to obtain the data they're seeking.…Parameter queries are great tools we can use…to ask users to enter the criteria…they want to use and they can use this same query…over and over again without going into design view…simply by changing the criteria.…In this video I'll show you how to create…both a single parameter query…and a multiple parameter query.…Let's go ahead and take a look at our…04 04 parameter query database.…

And we're going to focus on the 2016 sales table.…My first query will be a parameter query…that prompts the user to enter the sales person's name.…Let's go ahead and close the table.…Go to create.…Go into query design.…From the show table window I'll go ahead…and select the 2016 sales table…then close my show table window.…I want to include all of the fields in my query grid…so I will simply double-click on the asterisk…to add all the fields down below.…

Next I'll go ahead and add the sales person field…so that I can create that parameter prompt.…

Author

Released

Demonstrate your knowledge of Access by becoming a Microsoft Office Specialist. This course, created by Certified MOS Master Instructor Jennifer McBee, helps viewers prepare for exam 77-730, the Access 2016 MOS Certification Exam. Jennifer covers the five main areas of the exam: managing the Access environment, building tables, building forms, creating and managing queries, and designing reports.

The course begins with an overview of the certification program. Jennifer then walks you through all of the certification objectives. You can gain hands-on experience using the downloadable sample documents to practice as you follow along. The course concludes with a full-length practice test that emulates the Access 2016 MOS exam. Solutions are provided to each of the included challenges.