Problem-solving cases in Microsoft Access and Excel

Abstract

The book is organized into seven parts: • Database cases using Access • Decision support cases using the Excel Scenario Manager • Decision support cases using the Excel Solver • Decision support case using basic Excel functionality • Integration cases using Access and Excel • Advanced skills using Excel • Presentation skills Part 1 begins with two tutorials that prepare students for the Access case studies. Parts 2 and 3 each begin with a tutorial that prepares students for the Excel case studies. All four tutorials provide students with hands-on practice in using the software’s more advanced features—the kind of support that other books about Access and Excel do not provide. Part 4 asks students to use Excel’s basic functionality for decision support. Part 5 challenges students to use both Access and Excel to find a solution to a business problem. Part 6 is a set of short tutorials that teach the advanced skills students need to complete some of the Excel cases. Part 7 is a tutorial that hones students’ skills in creating and delivering an oral presentation to business managers. The next sections explore these parts of the book in more depth.