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

Establishing constraints with criteria

From the course: Access 2019 Essential Training

Start my 1-month free trial

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…

Contents