Replace "Chicago" with Edgar Llanas

Create an access report using the tablestore location information.

In the report header - enter a label "Edgar Llanas"

Add fields from the tables into the report.

Show the number of stores in each state and total number of stores in report footer. Show the report should be grouped bystate. In the group footer show the average square feet for all stores in each state. also in the report footer show the average square feet. Add relevant labels in group footer and report footer.

If the estimated population is less than 500000, show it in red.

Add an additional calculated item calledFuture-expansionnext to thestore size sq ft. This should show 10 % increase from the current store size

Do required formatting and adjustments and draw lines wherever required.

\f