Problem-Solving Cases in Microsoft� Access� and Excel�, International Edition

Ellen F. Monk is an Assistant Professor of Management Information Systems in the Lerner College of Business and Economics at the University of Delaware. Her areas of interest encompass enterprise resource planning systems and undergraduate MIS education, including databases, advanced spreadsheets and data analytics. Dr. Monk holds a B.S. in chemical engineering, an M.B.A., and a Ph.D. in MIS. Joseph A. Brady taught management information systems (MIS) courses at the University of Delaware from 1990 to 2009. Prior to launching his teaching career, Dr. Brady worked as a financial analyst for E. I. Du Pont de Nemours. Dr. Brady holds an M.S. in computer science, an M.B.A., and a Ph.D. in education. Gerry Cook has been the instructor for the Operations Management Technology program at Delaware Technical Community College since its inception in 2007. Prior to his teaching career, he worked as a process engineer and engineering manager in manufacturing for Mannington Mills, James River Corporation, and Mobil Chemical in a career spanning 27 years. Mr. Cook has a B.S. degree in industrial engineering from Lehigh University and an MBA from Oklahoma City University.

PART I. DATABASE CASES USING ACCESS.
Tutorial A. Database Design.
Tutorial B. Microsoft Access.
Case 1.
Case 2.
Case 3.
Case 4.
Case 5.
PART II. DECISION SUPPORT CASES USING EXCEL SCENARIO MANAGER.
Tutorial C. Building a Decision Support System in Excel.
Case 6.
Case 7.
PART III. DECISION SUPPORT CASES USING MICROSOFT EXCEL SOLVER.
Tutorial D. Building a Decision Support System Using Microsoft Excel Solver.
Case 8.
Case 9.
PART IV. DECISION SUPPORT CASE USING BASIC EXCEL FUNCTIONALITY.
Case 10.
PART C. INTEGRATION CASES USING ACCESS AND EXCEL.
Case 11.
Case 12.
PART VI: ADVANCED SKILLS USING EXCEL.
Tutorial E: Guidance for Excel Cases
PART VII: PRESENTATION SKILLS.
Tutorial F. Giving an Oral Presentation.