Please Show Me a Visual

Green Landscape is a small local company that provides lawn maintenance and landscaping to local commercial customers. Create a new Access Report using the following guidelines:

1. Create a new report using the Customer table.

2. Report Fields will include:

1. • Customer Number
   • Customer Name
   • Amount Paid
   • Current Balance
   • Supervisor Number

3. Group the report by Supervisor Number.

4. Sort the report alphabetically (A-Z) by Customer Number.

5. Create Totals for the Amount Paid and Current Balance columns.

6. Create a conditional formatting rule that displays the Current Balance amount in the text color of Red for any customer who has a current balance greater than $550.00.

7. Title the report Customer Financial Report.

8. Change the formatting of the column headings to a text color of Black and use the Bold attribute.

9. Add the Page Number to the report and center the Page Number at the bottom of the report.