Nelson Higher Education

Higher Education

Problem-Solving Cases in Microsoft® Access™ and Excel®, 11th Edition

  • Ellen Monk
  • Joseph Brady
  • Gerard S. Cook
  • ISBN-10: 1133628370
  • ISBN-13: 9781133628378
  • 304 Pages | Paperback
  • Previous Editions: 2013, 2012, 2011
  • COPYRIGHT: 2014 Published
Request a Copy for Review

Overview

About the Product

PROBLEM-SOLVING CASES IN MICROSOFT® ACCESS® AND EXCEL®, Eleventh 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 twelve 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. Instructor support materials can be found in the Instructor Downloads section of www.cengage.com/coursetechnology, and are accessible by Single-Sign On (SSO) username and password. Designed to facilitate classroom instruction, these resources include six new Hall of Fame cases, along with new solution files, syllabus, and Student Data Files.

Features

  • Realistic Business Scenarios: Students examine twelve 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.

About the Author

Ellen Monk

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 Brady

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.

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.

Table of Contents

PART 1: DATABASE CASES USING ACCESS.
Tutorial A: Database Design.
Tutorial B: Microsoft Access.
Case 1: Preliminary Case: The Outdoor Club.
Case 2: Ties To Go Database.
Case 3: Sweet Snacks Database.
Case 4: The Organic Farm Database.
Case 5: Creative Cakes Database.
PART 2: DECISION SUPPORT CASES USING EXCEL SCENARIO MANAGER.
Tutorial C: Building a Decision Support System in Excel.
Case 6: Crystal Lake Park Expansion Strategy Decision.
Case 7: The Postal Service Analysis.
PART 3: DECISION SUPPORT CASES USING MICROSOFT EXCEL SOLVER.
Tutorial D: Building a Decision Support System Using Microsoft Excel Solver.
Case 8: Global Electronics Assignment Problem.
Case 9: Appliance World Warehouse Inventory Management.
PART 4: DECISION SUPPORT CASE USING BASIC EXCEL FUNCTIONALITY.
Case 10: The Social Safety Net Analysis.
PART 5: INTEGRATION CASES USING ACCESS AND EXCEL.
Case 11: The Golf Pro Effectiveness Analysis.
Case 12: The State Lottery Analysis.
PART 6: ADVANCED SKILLS USING EXCEL.
Tutorial E: Guidance for Excel Cases.
PART 7: PRESENTATION SKILLS.
Tutorial F: Giving an Oral Presentation.

New to this edition

  • Updated Tutorials: These updated tutorials walk students through Microsoft® Access® and Excel® 2010, 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 twelve new cases and solving realistic problems with Microsoft® Access® and Excel®.
  • Updated Hall of Fame Downloads: Instructors and students can access six additional cases from the past in the Hall of Fame download section at www.cengage.com.