From the course: Cert Prep: Access 2016 Microsoft Office Specialist (77-730)

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Create a parameter query

Create a parameter query

From the course: Cert Prep: Access 2016 Microsoft Office Specialist (77-730)

Start my 1-month free trial

Create a parameter query

“

- [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…

Contents