Develop some reports and queries for running the businessDevelop some reviews and queries for working the enterprise
See the hooked up Database file (retailer and Regional gross sales)>!!
The database accommodates uncooked information on weekly retailer gross sales of pc tools in numerous gross sales areas. You will be utilizing entry to handle the information and switch it into helpful info.
The database consists of fields for report quantity, retailer identification quantity, gross sales area, merchandise quantity, merchandise description, unit value, models bought, and the weekly gross sales interval when the gross sales had been made.
Develop some reviews and queries to make this info extra helpful for working the enterprise. Gross sales and manufacturing managers need solutions to the next questions:
1. which merchandise must be restocked?
2. which shops and gross sales areas would profit from a promotional marketing campaign and extra advertising and marketing?
three. When (what time of 12 months) ought to merchandise be provided at full value and when ought to reductions be used?
You possibly can simply modify the database desk to search out and report your solutions print your reviews and outcomes of queris and when you modify it clarify why did you do this.