Lab: Quote Acceptability Report
The first objective of this lab assignment is to produce a quote acceptability report. The second objective is to break down the acceptability rate by customer type and order-taker.
1.
Produce a report, called Quote Acceptability Report, showing what percent of non-pending quotes have been accepted (status = accepted or completed), and what percent have been rejected (status = rejected). This report will show the same information in two different ways: The top half will show the information in terms of figures; the bottom half will show the same information in terms of a pie chart labeled properly.
Deliverable: A screen shot of the report
2.
Produce a report, called Quote Acceptability by Customer Type Report, showing each customer type and, for each, the percent of non-pending quotes that have been accepted (status = accepted or completed) by that type. Show these percents (and the corresponding customer types) in ascending order.
Deliverable: A screen shot of the report
3.
Produce a report, called Quote Acceptability by Order Taker Report, showing each order taker and, for each, the percent of accepted (status = accepted or completed) non-pending quotes that have been produced by that order taker. Show these percents (and the corresponding order takers) in ascending order.
Deliverable: A screen shot of the report
4.
Create a menu entitled Quote Acceptability. The three items on it will be the titles of the above three reports. Each will be a button that will take you to the corresponding report.
Deliverable: A screen shot of the menu