From the course: Access Essential Training (Office 365/Microsoft)

Unlock this course with a free trial

Join today to access over 24,300 courses taught by industry experts.

Establishing constraints with criteria

Establishing constraints with criteria - Microsoft Access Tutorial

From the course: Access Essential Training (Office 365/Microsoft)

Start my 1-month free trial Buy for my team

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 collected in the Two Trees customers. We can create a new query straight in the Design view without using the wizard by going to the Create tab and then clicking Query Design. That starts up a blank Query Design editor, and it automatically opens up the Add Tables panel over here on the right. Now, if you're not seeing this panel, you can toggle it on and off with this button here on the Query Design contextual tab, so it'll go off and back on again. This is just like the panel that we saw when we were creating our relationships, so we can take a look at all of our data tables, any linked tables, other queries in the database, or everything altogether. I'll just flip this back over to Tables. Then, I'll double-click on the…

Contents