1-14
(Learning Objective 1.2: What is an information system? How does it work? What are its
1-8 Dollar General Corporation: Wants to keep costs as low as possible so it does not
use an automated method for keeping track of inventory at each store. What decisions
have to be made before investing in an information system solution?
• Determine business problems—mismanagement of inventory, too little or too
much inventory, no ability to track inventory.
(Learning Objective 1.1: How are information systems transforming business and why
are they so essential for running and managing a business today? AACSB: Analytical
thinking, Application of knowledge.)
Improving Decision Making: Using Databases to Analyze Sales Trends:
Software skills: Database querying and reporting
Business skills: Sales Trend Analysis
1-9 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,
• 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?
The answers to these questions can be found in the Microsoft Access File named:
MIS14ch01_solutionfile.mdb
(Learning Objective 1.2: What is an information system? How does it work? What are its