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
From the course: Access 2019 Essential Training
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
What are queries?3m 19s
-
The Simple Query Wizard4m 22s
-
Build queries in Design view6m 2s
-
Establishing constraints with criteria4m 37s
-
Specifying criteria with wildcards3m 19s
-
Incorporating AND and OR statements4m 11s
-
Filtering with mathematical comparisons3m 23s
-
Create flexible queries with parameters4m 1s
-
Build expressions5m 21s
-
Obtain summary statistics7m 23s
-
-
-
-
-