Skip to main content
FlatWorld HomeFlatWorld Home
  • My Bookshelf

Table of Contents

    • About the Authors
    • Acknowledgments
    • Preface
    • 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.

      LoginBuy Now or Redeem Code

      • 2.1Microsoft Access

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • 2.2Creating Tables

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • 2.3Creating Queries

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • 2.4Making Seven Practice Queries

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • 2.5Creating Reports

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • 2.6Importing Data

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • 2.7Making Forms

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • 2.8Forming Relationships

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • 2.9Troubleshooting Common Problems

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

    • 3Case 1—Preliminary Case: Camping Equipment Rental

      Preview Mode

      Login or Purchase this book to read the remaining sections.

      LoginBuy Now or Redeem Code

      • 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.

        LoginBuy Now or Redeem Code

      • 3.2Assignment 1: Creating Tables

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • 3.3Assignment 2: Creating a Form, Queries, and a Report

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

    • 4Case 2: Eco Study Abroad Database

      Preview Mode

      Login or Purchase this book to read the remaining sections.

      LoginBuy Now or Redeem Code

      • 4.1Designing a Relational Database to Create Tables, Forms, Queries and Reports

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • 4.2Assignment 1: Creating the Database Design

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • 4.3Assignment 2: Creating the Database, Queries, and Reports

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

    • 5Case 3: Sunny Property Management Database

      Preview Mode

      Login or Purchase this book to read the remaining sections.

      LoginBuy Now or Redeem Code

      • 5.1Designing a Relational Database to Create Tables, Forms, Queries, and Reports

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • 5.2Assignment 1: Creating the Database Design

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • 5.3Assignment 2: Creating the Database, Queries, and Reports

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

    • 6Case 4: The Pet Transport Database

      Preview Mode

      Login or Purchase this book to read the remaining sections.

      LoginBuy Now or Redeem Code

      • 6.1Designing a Relational Database to Create Tables, Forms, Queries, and Reports

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • 6.2Assignment 1: Creating the Database Design

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • 6.3Assignment 2: Creating the Database, Queries, and Reports

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

    • 7Case 5: Spark Consulting Database

      Preview Mode

      Login or Purchase this book to read the remaining sections.

      LoginBuy Now or Redeem Code

      • 7.1Designing a Relational Database to Create Tables, Forms, Queries, and Reports

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • 7.2Assignment 1: Creating the Database Design

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • 7.3Assignment 2: Creating the Database, Queries, and Reports

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

    • Part 2Decision Support Cases Using Microsoft Excel Scenario Manager

      Preview Mode

      Login or Purchase this book to read the remaining sections.

      LoginBuy Now or Redeem Code

    • 8Tutorial C: Building a Decision Support System in Excel

      Preview Mode

      Login or Purchase this book to read the remaining sections.

      LoginBuy Now or Redeem Code

      • 8.1Building a Decision Support System in Excel

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • 8.2Spreadsheet and DSS Basics

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • 8.3Using Scenario Manager

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • 8.4Practicing with Scenario Manager

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • 8.5Reviewing Excel Basics

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

    • 9Case 6: Pandemic Planning

      Preview Mode

      Login or Purchase this book to read the remaining sections.

      LoginBuy Now or Redeem Code

      • 9.1Decision Support Using Excel Scenario Manager

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • 9.2Assignment 1: Creating a Spreadsheet for Decision Support

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • 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.

        LoginBuy Now or Redeem Code

    • 10Case 7: The State Investment Decision

      Preview Mode

      Login or Purchase this book to read the remaining sections.

      LoginBuy Now or Redeem Code

      • 10.1Decision Support Using Excel Scenario Manager

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • 10.2Assignment 1: Creating a Spreadsheet for Decision Support

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • 10.3Assignment 2: Using the Scenario Manager for Decision Support

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

    • Part 3Decision Support Cases Using Microsoft Excel Solver

      Preview Mode

      Login or Purchase this book to read the remaining sections.

      LoginBuy Now or Redeem Code

    • 11Tutorial D: Building a Decision Support System Using Microsoft Excel Solver

      Preview Mode

      Login or Purchase this book to read the remaining sections.

      LoginBuy Now or Redeem Code

      • 11.1Using Excel Solver

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • 11.2Extending the Example

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • 11.3Using Solver on a New Problem

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • 11.4Troubleshooting Solver

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

    • 12Case 8: The Meal Kit Production Problem

      Preview Mode

      Login or Purchase this book to read the remaining sections.

      LoginBuy Now or Redeem Code

      • 12.1Decision Support Using Excel

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • 12.2Assignment 1: Creating a Spreadsheet for Decision Support

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • 12.3Assignment 2: Using the Spreadsheet for Decision Support

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

    • 13Case 9: The Hybrid Work Model Case

      Preview Mode

      Login or Purchase this book to read the remaining sections.

      LoginBuy Now or Redeem Code

      • 13.1Decision Support Using Excel Solver

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • 13.2Assignment 1: Creating a Spreadsheet for Decision Support

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • 13.3Assignment 2: Using the Spreadsheet for Decision Support

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

    • Part 4Data Analysis with Access and Excel

      Preview Mode

      Login or Purchase this book to read the remaining sections.

      LoginBuy Now or Redeem Code

    • 14Case 10: The Insurance Analysis

      Preview Mode

      Login or Purchase this book to read the remaining sections.

      LoginBuy Now or Redeem Code

      • 14.1Data Analysis and Research with Microsoft Access and Excel

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • 14.2Assignment 1: Using Access for Data Inspection

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • 14.3Assignment 2: Using Access for Data Analytics

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • 14.4Assignment 3: Importing Data into Excel for Further Analysis

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • 14.5Assignment 4: Documenting Your Findings in a Memo

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

    • 15Case 11: Box Office Analysis

      Preview Mode

      Login or Purchase this book to read the remaining sections.

      LoginBuy Now or Redeem Code

      • 15.1Data Analysis with Microsoft Access and Excel

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • 15.2Assignment 1: Using Access and Excel for Decision Support

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • 15.3Assignment 2: Documenting Your Findings in a Memo

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

    • 16Tutorial E: Advanced Skills Using Microsoft Excel

      Preview Mode

      Login or Purchase this book to read the remaining sections.

      LoginBuy Now or Redeem Code

      • 16.1Guidance for Excel Cases

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

    • AData Files

      Preview Mode

      Login or Purchase this book to read the remaining sections.

      LoginBuy Now or Redeem Code

      • A.1Case 1: Camping Equipment Rental

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • A.2Case 2: Eco Study Abroad Database

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • A.3Case 3: Sunny Property Management Database

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • A.4Case 4: The Pet Transport Database

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • A.5Tutorial C: Building a Decision Support System in Excel

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • A.6Case 5: Spark Consulting

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • A.7Case 6: Pandemic Planning

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • A.8Case 7: The State Investment Decision

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • A.9Tutorial D: Building a Decision Support System Using Microsoft Excel Solver

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • A.10Case 8: The Meal Kit Production Problem

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • A.11Case 9: The Hybrid Work Model Case

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • A.12Case 10: The Insurance Analysis

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • A.13Case 11: Box Office Analysis

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code

      • A.14Tutorial E: Advanced Skills Using Microsoft Excel

        Preview Mode

        Login or Purchase this book to read the remaining sections.

        LoginBuy Now or Redeem Code