Higher Education

Problem- Solving Cases in Microsoft Access and Excel

Author(s): Ellen Monk | Gerard S Cook | Joseph Brady

ISBN: 9788131526293

Edition: 12th

© Year : 2015

₹760

Binding: Paperback

Imprint : Course Technology

Pages: 304

Refer Book > Order Inspection Copy >

PROBLEM-SOLVING CASES IN MICROSOFT® ACCESS® AND EXCEL®, Twelfth Annual Edition, helps students apply the Access® database management system and Excel® spreadsheet to effectively analyze and solve real-world business problems. Six individual tutorials in the text build a practical knowledge of each software application's capabilities, while 12 all-new case studies present scenarios and problems common in business. Further, a skill-building integration feature requires students to use Access® and Excel® together on cases, making this the most up-to-date, practical guide for these widely used software programs. 

  • Updated Tutorials: These updated tutorials walk students through Microsoft® Access® and Excel® 2013, imparting spreadsheet and database skills while preparing them for real-life, on-the-job application.
  • All-New Cases and Problems: Students gain valuable insight about today's marketplace from working 12 new cases and solving realistic problems with Microsoft® Access® and Excel®.
  • Realistic Business Scenarios: Students examine 12 brand new cases, each introducing a commonly occurring business issue, and learn how to use Excel® and Access® to analyze and help solve problems.
  • Skill-building Instruction: Hands-on tutorials demonstrate the ins and outs of Microsoft® Access® and Excel® 2010 and prepare students for the real workplace by testing their spreadsheet and database skills.
  • Data Analysis Techniques: A sixth tutorial covers Excel® Data Analysis Techniques, a more complex use of the Excel® spreadsheet that will deepen student understanding of the software.
  • Integration Cases: Two cases in the text require students to apply both Access® and Excel® simultaneously, helping to develop analytical skills while giving them valuable practice using newly acquired knowledge.
  • This edition has been completely updated for Microsoft® Access® and Excel® 2013.
  • This edition includes 12 new cases. Additionally, all tutorials have been updated to reflect Office 2013.

Part 1: DATABASE CASES USING ACCESS.

Tutorial A: Database Design.

Tutorial B: Microsoft Access.

Case 1: Preliminary Case; The Personal Training Database.

Case 2: Rent-a-Dress Database.

Case 3: The Import Food Market Database.

Case 4: The Music Festival Database.

Case 5: City Bike Rental Database.

Part 2: DECISION SUPPORT CASES USING EXCEL SCENARIO MANAGER.

Tutorial C: Building a Decision Support System in Excel.

Case 6: New England Energy Investment Strategy Decision.

Case 7: The City Hotel Recovery Analysis.

Part 3: DECISION SUPPORT CASES USING MICROSOFT EXCEL SOLVER.

Tutorial D: Decision Support Cases Using Microsoft Excel Solver.

Case 8: Duchess Cruises Ship Assignment Problem.

Case 9: Ed and Carla's Retirement Plan.

Part 4: DECISION SUPPORT CASE USING BASIC EXCEL FUNCTIONALITY.

Case 10: The University Arena Construction Decision.

Part 5: INTEGRATION CASES USING ACCESS AND EXCEL.

Case 11: The College GPA Analysis.

Case 12: The Nonprofit Donor Analysis.

Part 6: ADVANCED SKILLS USING EXCEL.

Tutorial E: Guidance for Excel Cases.

Part 7: PRESENTATION SKILLS.

Tutorial F: Giving an Oral Presentation.

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, 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.

 

Joseph Brady

Joseph A. Brady taught MIS courses at the University of Delaware from 1990 to 2009. Prior to his teaching career, he 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.

 

Gerard S. Cook

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.