Exam 77-424: Microsoft Access 2013 3.0 Create Queries 3.3 Utilize Calculated Fields and Grouping Within a Query: Use Basic Operators (COUNT, SUM)

Use the Total Row By default, the Total Row uses Group By for each Field. The other options include: Sum Avg Min Max Count SDev Var First Last Expression Where   2. Try it: Edit the Total Go to the Movie Column. Change the Total: Count   Go to the Price Column. Change the Total: Sum.   Keep going, please... Query Tools ->Design->Show/Hide->Totals