Problem-Solving Cases in Microsoft (R) Access (TM) and Excel (R), International Edition - Softcover

Monk, Ellen

Softcover

ISBN 10: 1285167619 ISBN 13: 9781285167619

Publisher: South-Western College Publishing, 2013

Synopsis

PROBLEM-SOLVING CASES IN MICROSOFT ACCESS AND EXCEL , 11E, International 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 this title

About the Author

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. Joseph A. Brady taught 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 has an M.S. degree in computer science, an MBA, and a Ph.D. in education. 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, Dr. Monk worked as a chemical engineer for Engelhard Industries and W. R. Grace and Co.'s Davison Chemical Division. She has a B.S. degree in chemical engineering, an MBA, and a Ph.D. in MIS.

Review

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.

Edition details

• Publisher: South-Western College Publishing
• Publication date: 2013
• Language: English
• ISBN 10: 1285167619
• ISBN 13: 9781285167619
• Binding: Paperback