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

  • Ellen Monk University of Delaware
  • Joseph Brady University of Delaware
  • Gerard S. Cook Delaware Technical and Community College
  • ISBN-10: 1133628370  |  ISBN-13: 9781133628378
  • 304 Pages
  • Previous Editions: 2013, 2012, 2011
  • © 2014 | Published
  • College Bookstore Wholesale Price = $74.75
  • 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

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/Benefits

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

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.

What's New

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

Learning Resource Bundles

Learning Resource Bundles

Convenient, cost-effective bundles provide additional resources to boost student engagement. Contact your Learning Consultant for more information.


Bundle: MIS 3 (with CourseMate Printed Access Card) + Problem-Solving Cases in Microsoft® Access™ and Excel®, 3rd
ISBN-10: 1285484517 | ISBN-13: 9781285484518
List Price = $165.95  | CengageBrain Price = $165.95  | College Bookstore Wholesale Price = $122.75

This Bundle Includes:

  • MIS 3
    List Price = $69.95  | CengageBrain Price = $69.95  | College Bookstore Wholesale Price = $52.50
  • Problem-Solving Cases in Microsoft® Access™ and Excel®
    List Price = $100.95  | CengageBrain Price = $100.95  | College Bookstore Wholesale Price = $74.75


Supplements

Instructor Supplements

Instructor Supplements

All supplements have been updated in coordination with the main title. Select the main title's "About the Solution" 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.

Principles of Information Systems  (ISBN-10: 1133629660 | ISBN-13: 9781133629665)

Prepare your students with a solid understanding of the principles of information systems using today’s most current, concise overview from leading authors Ralph Stair and George Reynolds. PRINCIPLES OF INFORMATION SYSTEMS, Eleventh Edition, relies on 14 captivating chapters to explore the core principles of IS and examine how it’s practiced today. Students gain a strong understanding of the latest developments and their impact on the rapidly changing role of today’s IS professional. As many as 140 new examples and references in each chapter keep the presentation as current as possible. New discussion focuses on the increased use of cloud computing throughout the world and the latest in mobile solutions and challenges in IS today. Students see, first-hand, how information systems can increase profits and reduce costs as they review new information on e-commerce and enterprise systems, artificial intelligence, virtual reality, green computing, and other issues reshaping IS today. Expanded material introduces the challenges and risks of computer crimes and hacking as well as cyberterrorism. This edition presents some of the most recent research on virtual communities and global IS work solutions as well as social networking. No matter what your students’ career plans, PRINCIPLES OF INFORMATION SYSTEMS, Eleventh Edition, and its resources can help you equip future professionals to function more effectively as employees, decision makers, and leaders in business today.

List Price = $299.95  | CengageBrain Price = $299.95  | College Bookstore Wholesale Price = $222.00


MIS 3  (ISBN-10: 1133627307 | ISBN-13: 9781133627302)

Created through a "student-tested, faculty-approved" review process with more than 200 students and faculty, MIS3, 3E is an engaging and accessible solution to accommodate the diverse lifestyles of today’s learners at a value-based price. MIS incorporates state-of-the-art coverage through numerous practical applications and offers emerging cases from the information systems field.

List Price = $69.95  | CengageBrain Price = $69.95  | College Bookstore Wholesale Price = $52.50


Student Supplements

Student Supplements

All supplements have been updated in coordination with the main title. Select the main title's "About the Solution" 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.

Principles of Information Systems  (ISBN-10: 1133629660 | ISBN-13: 9781133629665)

Gain a solid understanding of today’s principles of information systems when you use the most current overview from leading authors Ralph Stair and George Reynolds. PRINCIPLES OF INFORMATION SYSTEMS, Eleventh Edition, relies on 14 captivating chapters to explore the core principles of IS and examine how it’s practiced today. You gain a strong grasp of the latest developments and their impact on the rapidly changing role of today’s IS professional. As many as 140 new examples and references in each chapter keep the presentation as current as possible. New discussion focuses on the increased use of cloud computing throughout the world and the latest in mobile solutions and challenges in IS today. You see, first-hand, how information systems can increase profits and reduce costs as you review new information on e-commerce and enterprise systems, artificial intelligence, virtual reality, green computing, and other issues reshaping IS today. Expanded materials introduce the increasing challenges of today’s computer crimes and hacking as well as cyberterrorism. This edition presents some of the most recent research on virtual communities and global IS work solutions as well as the growing importance of social networking. No matter what your career plans, PRINCIPLES OF INFORMATION SYSTEMS, Eleventh Edition, can equip you to function more effectively as an employee, manager, or decision maker in business today.

List Price = $299.95  | CengageBrain Price = $299.95  | College Bookstore Wholesale Price = $222.00


MIS 3  (ISBN-10: 1133627307 | ISBN-13: 9781133627302)

Designed for and by today’s students in every detail, MIS3, 3E was developed within input from nearly 200 students and faculty members to provide a more engaging and accessible solution that appeals to different learning styles at a value-based price. This concise MIS3 includes all of the key concepts that your instructor requires and a full suite of learning aids to accommodate your busy lifestyle, including chapter-by-chapter study cards, self-quizzes, downloadable flash cards, and more.

List Price = $69.95  | CengageBrain Price = $69.95  | College Bookstore Wholesale Price = $52.50


Meet the Author

About the Author

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.