This exercise helps students understand how they can use database software to produce valuable information from raw data. The solutions provided here were created using the query wizard and report wizard capabilities of Microsoft Access. Students can, of course, create more sophisticated reports if they wish, but most information can be obtained from simple query and reporting functions. The main challenge is to get students to ask the right questions about the information.

Which products should be restocked?

Which stores and sales regions would benefit from a promotional campaign and additional marketing?

Which times of the year should products be offered at full price?

Which times of the year should products be discounted?