Problem-Solving Cases in Microsoft® Access® and Excel® | Ellen F. Monk, Joseph A. Brady, and Ryan T. Rodalunas

- Part 1Database Cases Using Microsoft Access
- 1Tutorial A: Database Design
  - 1.1Database Design
- 2Tutorial B: Microsoft Access
  Preview Mode
  Login or Purchase this book to read the remaining sections.
  Login Buy Now
  - 2.1Microsoft Access
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - 2.2Creating Tables
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - 2.3Creating Queries
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - 2.4Making Seven Practice Queries
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - 2.5Creating Reports
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - 2.6Importing Data
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - 2.7Making Forms
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - 2.8Forming Relationships
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - 2.9Troubleshooting Common Problems
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
- 3Case 1—Preliminary Case: Camping Equipment Rental
  Preview Mode
  Login or Purchase this book to read the remaining sections.
  Login Buy Now
  - 3.1Setting Up a Relational Database to Create Tables, Forms, Queries, and Reports
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - 3.2Assignment 1: Creating Tables
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - 3.3Assignment 2: Creating a Form, Queries, and a Report
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
- 4Case 2: Eco Study Abroad Database
  Preview Mode
  Login or Purchase this book to read the remaining sections.
  Login Buy Now
  - 4.1Designing a Relational Database to Create Tables, Forms, Queries and Reports
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - 4.2Assignment 1: Creating the Database Design
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - 4.3Assignment 2: Creating the Database, Queries, and Reports
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
- 5Case 3: Sunny Property Management Database
  Preview Mode
  Login or Purchase this book to read the remaining sections.
  Login Buy Now
  - 5.1Designing a Relational Database to Create Tables, Forms, Queries, and Reports
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - 5.2Assignment 1: Creating the Database Design
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - 5.3Assignment 2: Creating the Database, Queries, and Reports
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
- 6Case 4: The Pet Transport Database
  Preview Mode
  Login or Purchase this book to read the remaining sections.
  Login Buy Now
  - 6.1Designing a Relational Database to Create Tables, Forms, Queries, and Reports
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - 6.2Assignment 1: Creating the Database Design
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - 6.3Assignment 2: Creating the Database, Queries, and Reports
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
- 7Case 5: Spark Consulting Database
  Preview Mode
  Login or Purchase this book to read the remaining sections.
  Login Buy Now
  - 7.1Designing a Relational Database to Create Tables, Forms, Queries, and Reports
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - 7.2Assignment 1: Creating the Database Design
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - 7.3Assignment 2: Creating the Database, Queries, and Reports
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
- Part 2Decision Support Cases Using Microsoft Excel Scenario Manager
  Preview Mode
  Login or Purchase this book to read the remaining sections.
  Login Buy Now
- 8Tutorial C: Building a Decision Support System in Excel
  Preview Mode
  Login or Purchase this book to read the remaining sections.
  Login Buy Now
  - 8.1Building a Decision Support System in Excel
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - 8.2Spreadsheet and DSS Basics
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - 8.3Using Scenario Manager
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - 8.4Practicing with Scenario Manager
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - 8.5Reviewing Excel Basics
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
- 9Case 6: Pandemic Planning
  Preview Mode
  Login or Purchase this book to read the remaining sections.
  Login Buy Now
  - 9.1Decision Support Using Excel Scenario Manager
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - 9.2Assignment 1: Creating a Spreadsheet for Decision Support
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - 9.3Assignment 2: Using the Scenario Manager and “What-If” for Decision Support
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
- 10Case 7: The State Investment Decision
  Preview Mode
  Login or Purchase this book to read the remaining sections.
  Login Buy Now
  - 10.1Decision Support Using Excel Scenario Manager
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - 10.2Assignment 1: Creating a Spreadsheet for Decision Support
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - 10.3Assignment 2: Using the Scenario Manager for Decision Support
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
- Part 3Decision Support Cases Using Microsoft Excel Solver
  Preview Mode
  Login or Purchase this book to read the remaining sections.
  Login Buy Now
- 11Tutorial D: Building a Decision Support System Using Microsoft Excel Solver
  Preview Mode
  Login or Purchase this book to read the remaining sections.
  Login Buy Now
  - 11.1Using Excel Solver
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - 11.2Extending the Example
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - 11.3Using Solver on a New Problem
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - 11.4Troubleshooting Solver
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
- 12Case 8: The Meal Kit Production Problem
  Preview Mode
  Login or Purchase this book to read the remaining sections.
  Login Buy Now
  - 12.1Decision Support Using Excel
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - 12.2Assignment 1: Creating a Spreadsheet for Decision Support
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - 12.3Assignment 2: Using the Spreadsheet for Decision Support
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
- 13Case 9: The Hybrid Work Model Case
  Preview Mode
  Login or Purchase this book to read the remaining sections.
  Login Buy Now
  - 13.1Decision Support Using Excel Solver
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - 13.2Assignment 1: Creating a Spreadsheet for Decision Support
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - 13.3Assignment 2: Using the Spreadsheet for Decision Support
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
- Part 4Data Analysis with Access and Excel
  Preview Mode
  Login or Purchase this book to read the remaining sections.
  Login Buy Now
- 14Case 10: The Insurance Analysis
  Preview Mode
  Login or Purchase this book to read the remaining sections.
  Login Buy Now
  - 14.1Data Analysis and Research with Microsoft Access and Excel
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - 14.2Assignment 1: Using Access for Data Inspection
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - 14.3Assignment 2: Using Access for Data Analytics
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - 14.4Assignment 3: Importing Data into Excel for Further Analysis
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - 14.5Assignment 4: Documenting Your Findings in a Memo
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
- 15Case 11: Box Office Analysis
  Preview Mode
  Login or Purchase this book to read the remaining sections.
  Login Buy Now
  - 15.1Data Analysis with Microsoft Access and Excel
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - 15.2Assignment 1: Using Access and Excel for Decision Support
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - 15.3Assignment 2: Documenting Your Findings in a Memo
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
- 16Tutorial E: Advanced Skills Using Microsoft Excel
  Preview Mode
  Login or Purchase this book to read the remaining sections.
  Login Buy Now
  - 16.1Guidance for Excel Cases
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
- AData Files
  Preview Mode
  Login or Purchase this book to read the remaining sections.
  Login Buy Now
  - A.1Case 1: Camping Equipment Rental
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - A.2Case 2: Eco Study Abroad Database
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - A.3Case 3: Sunny Property Management Database
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - A.4Case 4: The Pet Transport Database
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - A.5Tutorial C: Building a Decision Support System in Excel
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - A.6Case 5: Spark Consulting
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - A.7Case 6: Pandemic Planning
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - A.8Case 7: The State Investment Decision
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - A.9Tutorial D: Building a Decision Support System Using Microsoft Excel Solver
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - A.10Case 8: The Meal Kit Production Problem
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - A.11Case 9: The Hybrid Work Model Case
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - A.12Case 10: The Insurance Analysis
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - A.13Case 11: Box Office Analysis
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now
  - A.14Tutorial E: Advanced Skills Using Microsoft Excel
    Preview Mode
    Login or Purchase this book to read the remaining sections.
    Login Buy Now