Use Design View to create a query that calculates the total sales per manufacturer. Select the Manufacturer and Unit Price fields from the Tires table and the Quantity from the Sales table. Use Builder to create a field that displays Unit Price multiplied by Quantity. Name this field Income. Show the Total row in the query window, and make the following selections: calculate the average of the Unit Price field; the sum of the quantity field; and the sum of the Income field. Sort the records in ascending order by the Manufacturer field. Save the query as Manufacturer Sales and run the query. With the Manufacturer Sales query selected, on the Home tab, click the Totals button in the Records group. Calculate the total quantity and total income of all the manufacturers. Save and close the query