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.
Establishing constraints with criteria
From the course: Access 2019 Essential Training
Establishing constraints with criteria
- [Instructor] In addition to gathering and displaying records from data tables, we can add filtering constraints to the query design grid to only display the exact records that we're interested in seeing. Let's see how this works by exploring the data that we've gathered for the Landon Hotel's guests. We're gonna start a new query here in Design view, go to the Create tab and click on Query Design. For this query, we're only interested in data from the Guests table, so I'll go ahead and double click on that to add it into our grid and then I'll go ahead and close the Show Table window. From the Guests table I wanna add in the fields for the first name of the guest. I'll go ahead and double click on that. The last name for the guest, the phone number, country and finally the state that they live in. At any point in time, we can go ahead and view our data sheet to see the results and this is exactly being pulled straight out of the Guests table, so we're not filtering it or anything…
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
-
-
-
-
-