From the course: Access 2019 Essential Training

Unlock the full course today

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

Create flexible queries with parameters

Create flexible queries with parameters

From the course: Access 2019 Essential Training

Start my 1-month free trial

Create flexible queries with parameters

- [Narrator] Sometimes you'll want to create a query framework that answers many variations on the same question. Instead of hard coding your queries to use the exact same criteria every time they're run, like what we've been doing, you can instead ask the users for the criteria when the query is run. This is called a parameter request, and they're another very useful tool to have when building your databases. Let's start by creating another query here in design view, and this one's gonna be pretty simple, we're just going to take a look at our guest data. From the guest table, I want to see the first name, the last name, and finally the country that the guest is from. Now, we've seen how to specify criteria that looks at a single country. For instance, if I come down here into the criteria row, underneath country, I can just type in France. And if I view this datasheet, we'll see all of our French guests. We have a total of five of them. Let's go back into design view. So instead of…

Contents