Use the Report Wizard to create a report based on the Cap$1$

Inventory table. Add the following fields to the report:

Category, Sport, and Cost, in that order. Group by the Category field. Sort in ascending order by Sport field. Find the Average of the Cost field. Be sure that the Layout is Stepped and that the Orientation is Portrait. For the report title, type Cap$1$ Average Cost by Category. Delete the controls that begin with Summary for 'Category'. Under Cost, click any text box control, and then set the Width property to $1$ and the Left property to $6.$ At the bottom of the report, in the last columb select the last control that displays the average. Set the Width property to $1$ and the Left property to $6\mathrm{.}5.$ Close the Property Sheet. Save and close the report.