Nelson Higher Education

Higher Education

Problem Solving Cases In Microsoft® Access and Excel, 14th Edition

  • Ellen Monk
  • Joseph Brady
  • Emilio Mendelsohn
  • ISBN-10: 1305868625
  • ISBN-13: 9781305868625
  • 304 Pages | Paperback
  • Previous Editions: 2016, 2015, 2014
  • COPYRIGHT: 2017 Published
Request a Copy for Review

Overview

About the Product

Show your students how to maximize the advantages of the latest Access database management system and Excel spreadsheet to effectively analyze and solve real-world business problems with PROBLEM-SOLVING CASES IN MICROSOFT® ACCESS AND EXCEL, 14TH ANNUAL EDITION. Packed with hands-on applications, this edition highlights six user-friendly tutorials that build students’ practical knowledge as they walk step-by-step through each software application’s capabilities. Twelve all-new case studies present scenarios and problems common in real-life practice while a wealth of online instructor resources support your teaching. In addition, a unique emphasis on skill-building integration requires students to use Access and Excel together on cases, demonstrating the power when these applications work together. Count on PROBLEM-SOLVING CASES IN MICROSOFT® ACCESS AND EXCEL to deliver today’s most up-to-date, practical guide for the widely used Access and Excel programs.

Features

  • REALISTIC BUSINESS SCENARIOS PROVIDE A BLEND OF CRITICAL EXCEL AND ACCESS PRACTICE: Each of the 12 all-new cases introduces a commonly occurring business issue, giving students hands-on experience using Excel and Access to analyze and solve real-world business problems.

  • SKILL-BUILDING INSTRUCTION THOROUGHLY DEMONSTRATES THE INS AND OUTS OF MICROSOFT® ACCESS AND EXCEL 2016: Hands-on tutorials prepare students for the real workplace by helping them develop their spreadsheet and database skills.

  • EMPHASIS ON DATA ANALYSIS TECHNIQUES REFINES STUDENTS’ UNDERSTANDING OF EXCEL: The text’s coverage of more complex uses of Excel spreadsheets deepens students’ understanding of the software.

  • INTEGRATION CASES HIGHLIGHT THE STRENGTH OF WORKING WITH ACCESS AND EXCEL TOGETHER: Two cases in the text require students to apply both Access and Excel simultaneously, helping readers see firsthand how the programs complement each other.

  • STUDENTS STRENGTHEN PRESENTATION SKILLS CRITICAL IN BUSINESS TODAY: The last tutorial gives students guidance in giving an oral presentation and includes information and instruction in planning the talk, creating and utilizing visual aids, and managing the audience effectively.

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.

Emilio Mendelsohn

Emilio Mendelsohn has taught in the Lerner College of Business and Economics at the University of Delaware as well as at Penn State University as an adjunct instructor of Management Information Systems (MIS) since 2012. He currently works as a risk manager for U.S. Bank in the Retail Payments Solutions Division. Formerly, Mr. Mendelsohn worked for JPMorgan Chase and Co. as an application manager in the Engineering and Technology Department and as an information risk analyst in the Information Technology Risk Management Department. Mr. Mendelsohn holds a B.S. as well as an M.S. in management information systems.

Table of Contents

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 V: 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.
Index.

New to this edition

  • UPDATED SCENARIO MANAGER AND SOLVER TUTORIALS REFLECT THE LATEST BUSINESS AND TECHNOLOGY ADVANCEMENTS: New tutorials emphasize today’s latest business challenges and the new features available in Access and Excel. For your convenience, all of the previous edition’s tutorials can also be downloaded from the instructor’s resources area on the book’s website.

Supplements

All supplements have been updated in coordination with the Main title.
Please see Main title page for new to this edition information.

Instructor Supplements

Companion Website  (ISBN-10: 1305868633 | ISBN-13: 9781305868632)

Find everything you need for your course in one place. This collection of book-specific lecture and class tools is available online via www.cengage.com/login. Access and download PowerPoint® presentations, images, instructor’s manual, videos, and more. You can also download all of the previous edition’s tutorials for reference or use in your course.