A summary query can be created by adding which row to the design grid of a select query? A. Arguments B. Group C. Summary D. Total

Arguments
Group
Summary
Total

The correct answer is: C. Summary

A summary query is a type of query that calculates summary statistics for a group of records. To create a summary query, you add a Summary row to the design grid of a select query. In the Summary row, you specify the fields that you want to summarize, the type of summary function that you want to use, and the group by criteria.

The Arguments row is used to specify the arguments for a function. The Group row is used to specify the groups that you want to summarize. The Total row is used to specify the totals that you want to calculate.

Here is an example of a summary query that calculates the total sales for each product:

SELECT ProductID, SUM(Quantity) AS TotalSales
FROM Sales
GROUP BY ProductID

This query will return a table with one row for each product, and the total sales for that product.