Request for consultation

Thanks for your request. You’ll soon be chatting with a consultant to get the answers you need.
{{formPostErrorMessage.message}} [{{formPostErrorMessage.code}}]
First Name is required. 'First Name' must contain at least 0 characters 'First Name' cannot exceed 0 characters Please enter a valid First Name
Last Name is required. 'Last Name' must contain at least 0 characters 'Last Name' cannot exceed 0 characters Please enter a valid Last Name
Institution is required.
Discipline is required.
Why are you contacting us today? is required. 'Why are you contacting us today?' must contain at least 0 characters 'Why are you contacting us today?' cannot exceed 0 characters Please enter a valid Why are you contacting us today?

Problem Solving Cases In Microsoft Access & Excel 15th Edition

Ellen Monk | Joseph Brady | Emilio Mendelsohn

Textbook Only Options

Traditional eBook and Print Options

{{collapseContainerClosed['9781337101332_txtbook_0'] ? 'Show More' : 'Show Less'}}
z

  • STARTING AT $43.99

  • ISBN-10: 1337669768
  • ISBN-13: 9781337669764
  • STARTING AT $45.49

  • ISBN-10: 1337101338
  • ISBN-13: 9781337101332
  • Bookstore Wholesale Price $83.25
  • RETAIL $110.95

Overview

Show your students how to successfully apply the advantages of the latest Access database management system and maximize the most recent version of Excel spreadsheet tools to analyze and solve real business problems with PROBLEM-SOLVING CASES IN MICROSOFT

Ellen Monk, University of Delaware

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, University of Delaware

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.

Emilio Mendelsohn, University of Delaware

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.
  • UPDATED SCENARIO MANAGER AND SOLVER TUTORIALS REFLECT THE LATEST BUSINESS AND TECHNOLOGY ADVANCEMENTS: Timely tutorials emphasize today’s latest business challenges and the new features available in Access and Excel.
  • REALISTIC BUSINESS SCENARIOS PROVIDE A BLEND OF CRITICAL EXCEL AND ACCESS PRACTICE: Each of this edition’s 12 all-new cases introduces a commonly occurring business issue, giving students hands-on experience using Excel and Access to analyze and solve rea
  • SKILL-BUILDING INSTRUCTION THOROUGHLY DEMONSTRATES THE INS AND OUTS OF USING MICROSOFT® ACCESS AND EXCEL 2016: Hands-on tutorials prepare your students for today’s actual workplace by helping them develop important spreadsheet and database skills.
  • EMPHASIS ON DATA ANALYSIS TECHNIQUES REFINES YOUR STUDENTS’ UNDERSTANDING OF EXCEL: The text’s coverage of more complex uses of Excel spreadsheets deepens students’ understanding of the software and its capabilities in business today.
  • INTEGRATION CASES HIGHLIGHT THE STRENGTH OF WORKING WITH ACCESS AND EXCEL TOGETHER: Two cases in this edition require students to apply both Access and Excel simultaneously, helping readers see first-hand how the programs complement each other to deliver
  • STUDENTS STRENGTHEN THEIR PRESENTATION SKILLS CRITICAL IN BUSINESS TODAY: The last tutorial gives your students insights and specific guidance in developing effective oral presentations. The authors offer timely information and instruction in planning the

Problem Solving Cases In Microsoft Access & Excel

TABLE OF CONTENTS

PART I: DATABASE CASES USING ACCESS.
Tutorial A: Database Design.
Tutorial B: Microsoft® Access.
Case 1. Setting Up a Relational Database to Create Tables, Forms, Queries, and Reports. Preliminary Case: Feline Novelties.
Case 2. Designing a Relational Database to Create Tables, Forms, Queries and Reports: The Travel Light Database.
Case 3. Designing a Relational Database to Create Tables, Forms, Queries, and Reports: The Personal Trainer Database.
Case 4. Designing a Relational Database to Create Tables, Forms, Queries, and Reports: The Rent UR Car Database.
Case 5. Designing a Relational Database to Create Tables, Forms, Queries, and Reports: The Household Help Database.
Part II: DECISION SUPPORT CASES USING EXCEL SCENARIO MANAGER.
Tutorial C: Building a Decision Support System in Excel.
Case 6. Decision Support Using Microsoft Excel: Philly Landscaping. Decision Support Using Microsoft Excel.
Case 7. Decision Support Using Microsoft Excel: Electric Car Financial Analysis.
Part III: DATA ANALYSIS CASES IN MICROSOFT ACCESS AND EXCEL..
Tutorial D. Data Analytics.
Case 8. Data Analytics Using Microsoft Access and Excel: Data Analytics of Boutique Hotel Reservations.
Case 9. Data Analytics Using Microsoft Access and Excel: Data Cleansing Task.
Part IV: DECISION SUPPORT CASE USING BASIC EXCEL FUNCTIONALITY.
Case 10. Decision Support Using Microsoft Excel: The State Pension Fund Analysis.
Part V: INTEGRATION CASES USING ACCESS AND EXCEL.
Case 11. Data Analysis and Research with Microsoft Access and Excel: FAA Wildlife Hazard Research.
Case 12. Decision Support with Microsoft Access and Excel: The Engagement Analysis.
Part VI: ADVANCED SKILLS USING EXCEL.
Tutorial E: Guidance for Excel Cases.
Part VII: PRESENTATION SKILLS.
Tutorial F: Giving an Oral Presentation.
Index.

Cengage provides a range of supplements that are updated in coordination with the main title selection. For more information about these supplements, contact your Learning Consultant.

FOR INSTRUCTORS

Problem Solving Cases In Microsoft Access & Excel

ISBN: 9781337101332
Show your students how to successfully apply the advantages of the latest Access database management system and maximize the most recent version of Excel spreadsheet tools to analyze and solve real business problems with PROBLEM-SOLVING CASES IN MICROSOFT® ACCESS AND EXCEL, 15TH ANNUAL EDITION. Packed with hands-on learning, this edition highlights six individual tutorials that build your students’ practical knowledge as they walk step-by-step through the capabilities of each software application. For the best in real-world practice, this edition offers 12 all-new case studies that present scenarios and problems that your students are likely to encounter on the job. In addition, a unique emphasis on skill-building integration demonstrates how to use Access and Excel together to resolve cases. Count on PROBLEM-SOLVING CASES IN MICROSOFT® ACCESS AND EXCEL to deliver today’s most up-to-date, practical guide for mastering the popular Access and Excel applications.

FOR STUDENTS

Problem Solving Cases In Microsoft Access & Excel

ISBN: 9781337101332
Discover how to successfully apply the advantages of the latest Access database management system and maximize the tools within today’s newest version of Excel spreadsheet to analyze and solve real business problems with PROBLEM-SOLVING CASES IN MICROSOFT® ACCESS AND EXCEL, 15TH ANNUAL EDITION. Packed with hands-on learning, this edition highlights six individual tutorials designed to build your practical knowledge as they walk you step-by-step through the capabilities of each software application. For the best in real-world practice, this edition offers 12 all-new case studies that present scenarios and problems you are likely to encounter on the job. In addition, a unique emphasis on skill-building integration shows you how to use Access and Excel together to resolve challenges within the cases. You can 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.