Run the Query, Again

The Query Criteria, is Not Null, should filter out all of the Records that do not have a Genre.

 

Did it work? Only one way to find out: Run it!

 

4. Try it: Run the Query

The Query in still open in Design View.
Go to Query Tools ->Design->Results->Run.

What Do You See? The Query returned 374 out of 401 Records. All of the Records have a Genre, there are no empties (null).

 

So, the Query Criteria worked.

What Else Do You See? The Movies are sorted by Year. The data is still not complete. Most of the Movies have a Rating.

 

Save your changes and Close the Query.

 

Let's create a Report and use this Query for the Record Source. 

Query Tools ->Design->Results->Run

Exam 77-885: Microsoft Access 2010

4. Creating and Managing Queries

4.3. Manipulate fields: Use Criteria to Filter Records