Cookies help us deliver our services. By using our services, you agree to our use of cookies. Learn more
Skip to content
Cover of Problem-Solving Cases in Microsoft® Access® and Excel® v17.0
Published: 
September 2023
Page Count: 
268
ISBN (Digital): 
978-1-4533-9480-9

Problem-Solving Cases in Microsoft® Access® and Excel®

Version 17.0
By Ellen F. Monk, Joseph A. Brady, and Ryan T. Rodalunas

Included Supplements

Key Features

  • Hands-on Access and Excel tutorials ensure students master these key business applications quickly and set the stage for quickly learning how to use other databases and spreadsheet programs
  • Cases are based on realistic scenarios business professional face every day
  • Strengthens learners’ abilities to analyze problems, examine alternative solutions, and implement those solutions by using Access and Excel
  • Encourages learners to think like business professionals
  • Information critical to startups or small businesses covered in Cases 2–5
  • Substantial focus on business analytics in Cases 8–11
  • Cases can be assigned to individuals or groups to simulate real-world team projects
  • Many cases require a summary memo documenting results to provide experience with reporting and explaining work product
  • More than 15 embedded hyperlinks to instructional videos
  • Supportive learning elements structure each Tutorial and Case
    • Tutorials
      • "At the Keyboard"
      • Instructional videos
      • Notes
      • "Troubleshooting Common Problems"
    • Cases
      • "Preview"
      • "Preparation"
      • "Background"
      • "Assignments"
  • Solution files and Data Sets are available under Other Supplements on this catalog page
  • All supplements are written by the textbook’s authors

Educators

Request Examination Copy Read Online Adopt This Book Customize this Book

Students

Online Access Price:  $39.95 Color Printed Textbook with Online Access Price:  $61.95
Buy This Book Redeem My Code

This textbook is suitable as a main text or supplemental resource for courses called Business Information Systems, Management of Information Systems (or MIS), Introduction to Information Systems (or IS), Strategic Information Systems, Capstone Information Systems, Business Analytics, Application Problem Solving, Technology Entrepreneurship, Digital Organization/Digital Leadership, Advanced Business Applications, Data Management and Analysis, Decision Support Systems, Decision Support Technologies, Decision Support Analysis, Modeling and Problem Solving with Spreadsheets and Databases, Database Systems, Data Collection and Modeling, Accounting Information Systems, Introduction to Accounting Spreadsheets, and Microsoft Office (or MS Office) courses with a specific focus on business-oriented applications, or similar course titles. The course is taught at the undergraduate and MBA levels at two- and four-year schools in departments of information systems, management information systems, information technology, business, computer science, computer and information systems, and accounting.


Problem-Solving Cases in Microsoft Access & Excel encourages students to apply basic knowledge learned in class to think through and solve the kinds of business problems they will encounter in their future careers. Five stand-alone tutorials based on the most current versions of Microsoft Office Access and Excel build practical skills, including how to use these applications both independently and together. Students then leverage this knowledge to address eleven cases that are based on realistic business scenarios. In the process, students hone self-learning abilities, improve critical thinking skills, gain familiarity with business analytics, and become comfortable solving problems independently. As a result, they develop the confidence and capabilities to launch their own startups more successfully or be valuable organizational contributors from their first days on the job.


The book is organized into four parts. Part 1 begins with two tutorials that prepare students for the five subsequent Access case studies. Parts 2 and 3 each begin with a tutorial that prepares students for the next four Excel case studies. All tutorials provide students with practice using the software’s features while specifically preparing them to address the following case studies. Part 4 challenges students to use both Access and Excel to find a solution to a business problem based on two separate case studies. The final part also includes a concluding tutorial that covers advanced Excel skills.

New in This Version

  • All eleven cases are completely new
  • Cases reflect Office 365’s suite of applications
  • Stronger focus on data-analysis activities
FlatWorld Homework System

FlatWorld Homework

FlatWorld Homework includes multi-format questions written specifically for your FlatWorld book, which you can access through our stand-alone interface or integrate with your learning management system.

Request a demo

In order to give you the best experience, it is important that we have accurate data about your correct school. If you are unable to find the correct school above, please enter the name and web address here so that we can add it to our system.



Instructor’s Manual

Instructor’s Manual

The Instructor’s Manual guides you through the main concepts of each chapter and important elements such as learning objectives, key terms, and key takeaways. Can include answers to chapter exercises, group activity suggestions, and discussion questions.

Instructor’s Manual

PowerPoint Lecture Notes

PowerPoint Lecture Notes

A PowerPoint presentation highlighting key learning objectives and the main concepts for each tutorial are available for you to use in your classroom. You can either cut and paste sections or use the presentation as a whole.

PowerPoint Lecture Notes

Sample Syllabi

Sample Syllabi

Sample syllabi provide useful templates to help new faculty adopters revise their teaching plans to match their assigned FlatWorld textbook or lend insights to existing adopters on how to organize their classes.

Download
Other Supplements

Other Supplements

Starter and Solution files to accompany the Tutorials and Cases in the text.

At FlatWorld, we take pride in providing a range of high-quality supplements alongside our titles, to help instructors teach effectively. Supplements are available for instructors who have registered their adoption with us. If you need to review or preview something specific, please contact us.


Sign up for FlatWorld

Already registered? Sign in here

Ellen F. Monk University of Delaware

Ellen F. Monk (PhD Brunel University) is Associate Professor of Management Information Systems and Associate Chair of MIS 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.

Joseph A. Brady University of Delaware

Joseph Brady (PhD University of Delaware) taught management information systems 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.

Ryan T. Rodalunas University of Delaware

Ryan T. Rodalunas (DBA Creighton University) is an Instructor of Management Information Systems and Director of Technology Projects in the Lerner College of Business and Economics at the University of Delaware. His interests include experiential learning, project management, and data analytics. Prior to his teaching career, Dr. Rodalunas worked in both the public and private sectors as a consultant for tech start-ups and project manager in the healthcare industry.

Back to top