About The Author

Ellen Monk

Ellen F. Monk has been teaching Information Systems at the Lerner College of Business and Economics at the University of Delaware since 1989. Prior to her teaching career, Ellen worked as a chemical engineer for Engelhard Industries and W. R. Grace & Cos Davison Chemical Division. Ms. Monk has a B.S. degree in Chemical Engineering and an MBA.

Spring W. Davidson

Spring W. Davidson has been teaching Information Systems at the Lerner College of Business and Economics at the University of Delaware since 1996. Prior to her teaching career, Spring worked as a software development manager and systems analyst for several companies including Accenture, CSC, Bethlehem Steel, and Armco Steel. Ms. Davidson has a B.S. degree in Computer Science and an MBA.

Joseph Brady

Joseph A. Brady currently teaches MIS courses at the University of Delaware, where he has taught since 1990. Prior to his teaching career, he worked as a financial analyst for E.I. Dupont de Nemours. Dr. Brady has an M.S. degree in Computer Science, an MBA, and a Ph.D. in Education. He is also a Certified Public Accountant. Joe is the co-author of five previous editions of Problem-Solving Cases, as well as Advanced Cases in MIS.

Problem Solving Cases in Microsoft® Access and Excel®, 7th Edition

Ellen Monk- University of Delaware

Spring W. Davidson- University of Delaware

Joseph Brady- University of Delaware

ISBN-10: 0324789106 | ISBN-13: 9780324789102

230 Pages Paperbound

© 2010 Published

Overview

Apply Access and Excel effectively and efficiently to solve real-world business problems in this seventh edition of PROBLEM-SOLVING CASES IN MICROSOFT ACCESS AND EXCEL. With six individual tutorials that build a practical knowledge of Microsoft Office 2007 Access and Excel capabilities, this book sets the groundwork for applying these database and spreadsheet skills to actual scenarios. These scenarios take the form of 12 all-new case studies, which introduce problems that are likely to face today's business professionals and allow readers to apply the information gleaned from the tutorials to solve them. The seventh edition continues to offer a tutorial covering data analysis techniques and a second integration case, affording readers the most up-to-date, practical education in the most commonly used software programs.

Table of Contents

Part I: DATABASE CASES USING ACCESS.

Tutorial A: Database Design.

Tutorial B: Microsoft Access Tutorial.

Case 1: Preliminary Case: Nature Tourism.

Case 2: Textbook Leasing.

Case 3: Parks Summer Job Database.

Case 4: The Car Share Reservation Database.

Case 5: The Gourmet Tea Inventory Database.

Part II: DECISION SUPPORT CASES USING EXCEL SCENARIO MANAGER.

Tutorial C: Building a Decision Support System in Excel.

Case 6: The Choc-a-bloc Candy-Making Decision.

Case 7: The Fair Trade Shop Decision.

Part III: DECISION SUPPORT CASES USING EXCEL SOLVER.

Tutorial D: Building a Decision Support System Using the Excel Solver

Case 8: The Bakery Bread Production Problem.

Case 9: Big State University Freshman Acceptance Problem.

Part IV: DECISION SUPPORT CASES USING BASIC EXCEL FUNCTIONALITY.

Case 10: Non-Bored Games Operating Budget.

Part V: INTEGRATION CASE: USING ACCESS AND EXCEL.

Case 11: The Hometown Tree Farm Analysis.

Case 12: The Golf Tour Game Prediction.

Part VI: DATA ANALYSIS TECHNIQUES.

Tutorial E Data Analysis Techniques.

Part VII: PRESENTATION SKILLS.

Tutorial F Giving an Oral Presentation.