Synopses & Reviews
PROBLEM-SOLVING CASES IN MICROSOFT ACCESS AND EXCEL helps you apply Access and Excel effectively and efficiently to solve real-world business problems. With 6 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 new case studies, which introduce problems that today's business professionals are likely to face. The cases allow you to apply the information gleaned from the tutorials to solve the problems. With features like integration cases that require readers to use both Access and Excel together, this book affords the most up-to-date, practical education in the most commonly used software programs.
Synopsis
PROBLEM-SOLVING CASES IN MICROSOFT ACCESS AND EXCEL, 9th Edition helps you apply the Access database management system and Excel spreadsheet to effectively analyze and solve real-world, business problems. Six individual tutorials build a practical knowledge of each software application's capabilities, while twelve all-new case studies present scenarios and problems common in business. Further, a skill-building integration feature requires readers to use Access and Excel together on cases, making this the most up-to-date, practical guide for these widely used software programs.
About the Author
Professor 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, Ms. Monk worked as a chemical engineer for Engelhard Industries and W. R. Grace and Cos Davison Chemical Division. Ms. Monk has a B.S. degree in Chemical Engineering, an MBA, and is pursuing her doctoral degree in MIS. Joseph A. Brady taught M.I.S. courses at the University of Delaware from 1990 to 2009. 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 M.B.A., and a Ph.D. in Education. Gerry Cook has been the instructor for the Operations Management Technology program at Delaware Technical and 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.
Table of Contents
PART I: DATABASE CASES USING ACCESS. Tutorial A: Database Design. Tutorial B: Microsoft Access Tutorial. Case 1: Preliminary Case: Veggie Box Delivery. Case 2: Internet Jets Reservation System Database. Case 3: The Intramural Sports Database. Case 4: T-shirts Etc. Order Database. Case 5: The Precious Metal Depository Database. PART II: DECISION SUPPORT CASES USING EXCEL SCENARIO MANAGER. Tutorial C: Building a Decision Support System in Excel. Case 6: Future Cars Inc. Product Strategy Decision. Case 7: Health Care Coverage Decision at Big Dog Collars. PART III: DECISION SUPPORT CASES USING EXCEL SOLVER. Tutorial D: Building a Decision Support System. Case 8: Kuhlman's Department Store Media Problem. Case 9: Green Jeans, LLC Sales and Operations Plan. PART IV: DECISION SUPPORT CASES USING BASIC EXCEL FUNCTIONALITY. Case 10: The College Return on Investment Analysis. PART V: INTEGRATION CASE: USING ACCESS AND EXCEL. Case 11: Baseball Offensive Performance Analysis. Case 12: The Brewery Index Calculation. PART VI: ADVANCED EXCEL SKILLS. Tutorial E: Guidance for Excel Cases. PART VII: PRESENTATION SKILLS. Tutorial F: Giving an Oral Presentation.