Problem Solving Cases in Microsoft® Access and Excel®, 9th Edition

  • Ellen Monk University of Delaware
  • Joseph Brady University of Delaware
  • Gerard S. Cook Delaware Technical and Community College
  • ISBN-10: 1111820511
  • ISBN-13: 9781111820510
  • 224 Pages Paperback 
  • Previous Editions: 2011, 2010, 2009
  • © 2012 | Published
  • College Bookstore Wholesale Price = $74.50 
» Request an Online Copy for Review  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 The Solution

Overview

PROBLEM-SOLVING CASES IN MICROSOFT® ACCESS® AND EXCEL®, 9th 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, Student Data Files, and a new Instructor's Manual.


Additional Product Information

Features/Benefits

  • Realistic Business Scenarios: Students examine twelve 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.
  • Extra Cases: In addition to the cases in the text, students and instructors can access Hall of Fame cases from past editions at www.cengage.com.
  • 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.

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.

Best Buy Packages

Other Popular Packages

Choose the textbook packaged with the resources that best meet your course and student needs. Contact your Cengage Learning representative for more information.


Bundle: Fundamentals of Information Systems (with SOC Printed Access Card), 6th + Problem Solving Cases in Microsoft® Access and Excel®, 9th
ISBN-10: 1133219438  | ISBN-13: 9781133219439
List Price = $189.95  | CengageBrain Price = $151.49  | College Bookstore Wholesale Price = $140.50

This Bundle Includes:

  • Fundamentals of Information Systems
    List Price = $189.95  | CengageBrain Price = $151.49  | College Bookstore Wholesale Price = $140.50
  • Problem Solving Cases in Microsoft® Access and Excel®
    List Price = $100.95  | CengageBrain Price = $80.49  | College Bookstore Wholesale Price = $74.50


Bundle: New Perspectives on Microsoft® Excel® 2010: Comprehensive + Problem Solving Cases in Microsoft® Access and Excel®, 9th
ISBN-10:  1133615783 | ISBN-13:  9781133615781
List Price = $191.95  | CengageBrain Price = $153.49  | College Bookstore Wholesale Price = $142.00

This Bundle Includes:

  • New Perspectives on Microsoft® Excel® 2010: Comprehensive
    List Price = $169.95  | CengageBrain Price = $135.49  | College Bookstore Wholesale Price = $126.00
  • Problem Solving Cases in Microsoft® Access and Excel®
    List Price = $100.95  | CengageBrain Price = $80.49  | College Bookstore Wholesale Price = $74.50


Table of Contents

PART I: DATABASE CASES USING ACCESS.
Tutorial A: Database Design.
Tutorial B: Microsoft Access Tutorial.
Case 1: Preliminary Case: Veggie Box Delivery.
Case 2: Internet Jets Reservation System Database.
Case 3: The Intramural Sports Database.
Case 4: T-shirts Etc. Order Database.
Case 5: The Precious Metal Depository Database.
PART II: DECISION SUPPORT CASES USING EXCEL SCENARIO MANAGER.
Tutorial C: Building a Decision Support System in Excel.
Case 6: Future Cars Inc. Product Strategy Decision.
Case 7: Health Care Coverage Decision at Big Dog Collars.
PART III: DECISION SUPPORT CASES USING EXCEL SOLVER.
Tutorial D: Building a Decision Support System.
Case 8: Kuhlman's Department Store Media Problem.
Case 9: Green Jeans, LLC Sales and Operations Plan.
PART IV: DECISION SUPPORT CASES USING BASIC EXCEL FUNCTIONALITY.
Case 10: The College Return on Investment Analysis.
PART V: INTEGRATION CASE: USING ACCESS AND EXCEL.
Case 11: Baseball Offensive Performance Analysis.
Case 12: The Brewery Index Calculation.
PART VI: ADVANCED EXCEL SKILLS.
Tutorial E: Guidance for Excel Cases.
PART VII: PRESENTATION SKILLS.
Tutorial F: Giving an Oral Presentation.

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.

Fundamentals of Information Systems  (ISBN-10: 0840062184 | ISBN-13: 9780840062185)

Equip your students with a solid understanding of the fundamentals of information systems with the latest, concise overview from leading authors Ralph Stair and George Reynolds. Fundamentals of Information Systems, 6e uses nine short chapters to explore the core principles of IS, provide students with an engaging overview of the IS discipline today, and detail the rapidly changing role of today's IS professional. Your students will gain a strong understanding of the changing role of today's IS professional with this book's wealth of current examples and IS references. The book provides new discussion on multimedia in today's business, application development for the iPhone, iPad, and similar devices, cloud computing, forecasting, and other issues reshaping IS today. New materials and examples on environmental design and green computing prepare students for today's workforce. New examples of supply chain management (SCM) and customer relationship management (CRM) better equip students for business success. This edition presents some of the most recent research on virtual communities and work structures, including how social networking sites, such as Facebook and Twitter, are assisting virtual teams and how companies are effectively using virtual organizational structures with mobile workers. No matter what their major, students can use the principles in Fundamentals of Information Systems, 6e to function more effectively as workers, managers, decision makers, and organizational leaders in business today.

List Price = $189.95  | CengageBrain Price = $151.49  | College Bookstore Wholesale Price = $140.50


Principles of Information Systems  (ISBN-10: 0538478292 | ISBN-13: 9780538478298)

Help your students gain the foundation they need to better understand the IS discipline and how IS courses relate to the rest of their business courses. This edition from leading authors and practitioners Ralph Stair and George Reynolds focuses on today's core IS principles that are most important for every business student to know. Your students will gain a strong understanding of the changing role of today's IS professional with this book's wealth of current examples and IS references. NEW detailed coverage of multimedia in business, application development for the iPhone, iPad, and similar devices, cloud computing and updates of forecasting demonstrate issues reshaping IS today. NEW materials and examples on environmental design and green computing prepare students for today's workplace. NEW examples of supply chain management (SCM) and customer relationship management (CRM) better equip your students for business success. This edition presents some of the most recent research on virtual communities and work structures, including how social networking sites, such as Facebook and Twitter, are assisting virtual teams and how companies are effectively using virtual organizational structures with mobile workers. Count on Stair/Reynolds' Principles of Information Systems, 10e to provide the insights students need to function more efficiently and effectively as workers, managers, decision makers, and organizational leaders in business today.

List Price = $280.95  | CengageBrain Price = $224.49  | College Bookstore Wholesale Price = $208.00


MIS2  (ISBN-10: 1111533962 | ISBN-13: 9781111533960)

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

List Price = $65.95  | CengageBrain Price = $65.95  | College Bookstore Wholesale Price = $48.75


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.

Fundamentals of Information Systems  (ISBN-10: 0840062184 | ISBN-13: 9780840062185)

Gain a solid understanding of the core fundamentals of information systems with this concise overview from leading authors Ralph Stair and George Reynolds. Fundamentals of Information Systems, 6e explores the core principles of IS you need to become a better worker, manager, decision maker, or organizational leader in business today. You'll find a useful overview of the IS discipline that demonstrates the rapidly changing role of today's IS professional. More than 50 new references in each chapter highlight the latest IS topics and examples, while new opening vignettes and updated cases and special interest boxes demonstrate the emphasis today's organizations place on innovation and speed. New discussion about multimedia in today's business, application development for the iPhone, iPad, and similar devices, of cloud computing and forecasting, as well as new examples of supply chain management (SCM) and customer relationship management (CRM) better equip you for business success. New materials and examples on environmental design and green computing prepare students for today's workforce. This edition presents some of the most recent research on virtual communities and work structures, including how social networking sites, such as Facebook and Twitter, assist virtual teams and how many companies today are using virtual organizational structures to manage mobile workers.

List Price = $189.95  | CengageBrain Price = $151.49  | College Bookstore Wholesale Price = $140.50


Principles of Information Systems  (ISBN-10: 0538478292 | ISBN-13: 9780538478298)

Gain the solid foundation you need to better understand the entire IS discipline and how IS courses relate to the rest of your business studies and career with this textbooks from leading authors Ralph Stair and George Reynolds. This edition clearly highlights how to use IS concepts within the context of business, particularly with the emphasis today's organizations place on innovation and speed. You can count on Stair/Reynolds' Principles of Information Systems to provide the insights you need to function more efficiently and effectively as a worker, manager, decision maker, or organizational leader in business today. Closely examine the changing role of today's IS professional with this edition's wealth of current examples and IS references available. New detailed coverage of multimedia in business, application development for the iPhone, iPad, and similar devices, cloud computing and new updates of forecasting demonstrate issues reshaping IS today. Coverage of current trends in environmental design and green computing prepare you for today's workplace. Examples of supply chain management (SCM) and customer relationship management (CRM) better equip you for business success. This edition presents some of the most recent research on virtual communities and work structures, including how social networking sites, such as Facebook and Twitter, are assisting virtual teams and how companies are effectively using virtual organizational structures with mobile workers.

List Price = $280.95  | CengageBrain Price = $224.49  | College Bookstore Wholesale Price = $208.00


MIS2  (ISBN-10: 1111533962 | ISBN-13: 9781111533960)

Designed for and by today's students in every detail, MIS2 was developed from nearly 150 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 MIS2 includes all of the key concepts that your instructors require 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. MIS2 incorporates state-of-the-art coverage through numerous practical applications and offers emerging cases from today's information systems field.

List Price = $65.95  | CengageBrain Price = $65.95  | College Bookstore Wholesale Price = $48.75


Meet the Author

About the Author

Ellen Monk

Professor 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, Ms. Monk worked as a chemical engineer for Engelhard Industries and W. R. Grace & Cos Davison Chemical Division. Ms. Monk has a B.S. degree in Chemical Engineering, an MBA, and is pursuing her doctoral degree 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. Dupont 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.

Custom

Custom learning materials let you create a digital or print course solution in the style and format best for you and your learners. Maximize engagement and achieve desired outcomes with the aid of our academic and digital experts, who have years of experience helping instructors customize material to specific course needs.
Create your custom solution »