Higher Education

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

  • Ellen Monk University of Delaware
  • Joseph Brady University of Delaware
  • Gerard S. Cook Delaware Technical and Community College
  • Emilio Mendelsohn University of Delaware
  • ISBN-10: 1305408721  |  ISBN-13: 9781305408722
  • 304 Pages
  • Previous Editions: 2015, 2014, 2013
  • © 2016 | Published
  • College Bookstore Wholesale Price = $84.00
  • Newer Edition Available
  *Why an online review copy?
  • It's the greener, leaner way to review! An online copy cuts down on paper and on time. Reduce the wait (and the weight) of printed texts. Your online copy arrives instantly, and you can review it anytime from your computer or favorite mobile device.

If you prefer a print copy to review, please contact your representative.

About

Overview

Packed with hands-on applications, PROBLEM-SOLVING CASES IN MICROSOFT® ACCESS and EXCEL, 13th Annual Edition, helps students apply the Access database management system and Excel spreadsheet to effectively analyze and solve real-world business problems. Six user-friendly tutorials in the text build practical knowledge as they walk students step-by-step through each software application's capabilities, while 12 all-new case studies present scenarios and problems common in real-life practice. There is a wealth of instructor resources provided online. In addition, 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.

Features and Benefits

  • Realistic Business Scenarios: 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 demonstrating the ins and outs of Microsoft® Access and Excel 2013, hands-on tutorials prepare students for the real workplace by developing their spreadsheet and database skills.
  • Data Analysis Techniques: The text's coverage of more complex uses of Excel spreadsheets deepens student understanding of the software.
  • Integration Cases: Two cases in the text require students to apply both Access and Excel simultaneously, helping students see firsthand how the programs complement each other.
  • Presentation Skills: The last Tutorial gives students guidance for giving an oral presentation and includes information and guidance for planning their talk, creating and utilizing visual aids, and managing their audience effectively.

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

What's New

  • Updated Tutorials: Completely up to date, user-friendly tutorials walk students step-by-step through Microsoft® Access and Excel 2013, providing essential spreadsheet and database skills while preparing them for real-life, on-the-job applications and challenges.
  • All-New Cases and Problems: Students gain valuable insight about today's marketplace through hands-on experience working 12 new cases and solving realistic problems with Microsoft® Access and Excel. These cutting-edge cases and problems reflect the latest trends and issues from the field.

Supplements

All supplements have been updated in coordination with the main title. Select the main title's "About" tab, then select "What's New" for updates specific to title's edition.

For more information about these supplements, or to obtain them, contact your Learning Consultant.

Instructor Supplements

Web Site  (ISBN-10: 130540873X | ISBN-13: 9781305408739)

Access the solutions manual and student data files on the instructor companion site.

Meet the Author

Author Bio

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

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.

Emilio Mendelsohn

Emilio Mendelsohn joined the Lerner College of Business and Economics at the University of Delaware in 2012 as an adjunct professor of Management Information Systems. 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 information risk analyst in the Information Technology Risk Management Department. Mr. Mendelsohn has B.S. and M.S. degrees in management information systems.