Run the Query

2. Try it: Run the Query

The Query is open in Design View.

Go to Query Tools ->Design->Results->Run.

 

What Do You See? The Query returned 401 Records. The Movies are sorted by Year.

 

What Else Do You See? The data is not complete. Some of the Movies have a Rating, Some do not. Some do not have a Genre.

 

Close the Query. Keep going...

Query Tools ->Design->Results->Run

Exam 77-885: Microsoft Access 2010

4. Creating and Managing Queries

4.3. Manipulate fields