Exam 77-424: Microsoft Access 2013 3.0 Create Queries 3.3 Utilize Calculated Fields and Grouping Within a Query: Group and Summarize Data

Group By Totals This option will combine the repeated Ratings.   Before You Begin: Return to Design View. Go to Home->Views->View->Design View.   Still Before You Begin: Edit the Query Delete the Movie Field. There will be only two fields: Genre and Rating.   5. Try it: Edit the Select Query Go to Query Tools ->Design->Show/Hide. Click on Totals.   What Do You See? When you click on Totals the Query grid will show the Total Row. The default is Group By.   Try This, Too: Add Criteria Type the Rating Criteria: Is Not Null. Type the Genre Criteria: Is Not Null.   This will return the movies that do have (Is Not Null) a Rating or Genre in tblMovies.   Keep going... Query Tools ->Design->Show/Hide->Totals