Run the Query, Again

6. Try it: Run the Query

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

 

What Do You See? How many records do you see? Now, there are 37 Records, not 401. Each Genre has Ratings. There are no duplicates.

 

Try This, Too: Return to Design View.

Go to Home->Views->View->Design View.

 

Keep going..

Query Design Tools ->Design->Results->Run

Exam 77-885: Microsoft Access 2010

4. Creating and Managing Queries

4.1. Construct queries: Create a Select Query