Problem Solving Cases In Microsoft Access & Excel

✍ Scribed by Ellen Monk, Joseph Brady, Emilio Mendelsohn

• Publisher: Cengage Learning
• Year: 2019
• Tongue: English
• Leaves: 242
• Edition: 16
• Category: Library

✦ Synopsis

Learn how to analyze and successfully solve today's real business problems using the latest Microsoft Office Access database management system and the most recent version of Excel spreadsheet tools. Packed with hands-on learning opportunities, Monk/Brady/Mendelsohn's PROBLEM-SOLVING CASES IN MICROSOFT ACCESS AND EXCEL, 16E features five individual tutorials designed to build your practical knowledge as you walk step-by-step through the capabilities of each software application. Twelve all-new case studies challenge you to use the software applications to resolve scenarios and problems you 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 challenges within each case. Trust today's most up-to-date, practical guide for mastering critical Access and Excel skills in a business context.

✦ Table of Contents

Cover
Brief Contents
Preface
Part 1: Database Cases Using Microsoft Access
Tutorial A: Database Design
Review of Terminology
Database Design
Practice Database Design Problem
Tutorial B: Microsoft Access
Creating Tables
Creating Queries
Making Seven Practice Queries
Creating Reports
Importing Data
Making Forms
Forming Relationships
Troubleshooting Common Problems
Case 1: Preliminary Case: Dog Hikes
Preview
Preparation
Background
Assignment 1: Creating Tables
Assignment 2: Creating a Form, Queries, and a Report
Deliverables
Case 2: The Parks and Recreation Database
Preview
Preparation
Background
Assignment 1: Creating the Database Design
Assignment 2: Creating the Database, Queries, and Reports
Deliverables
Case 3: The Senior Concierge Database
Preview
Preparation
Background
Assignment 1: Creating the Database Design
Assignment 2: Creating the Database, Queries, and Reports
Deliverables
Case 4: The Fresh Fish Distributor Database
Preview
Preparation
Background
Assignment 1: Creating the Database Design
Assignment 2: Creating the Database, Queries, and Reports
Deliverables
Case 5: The Volunteer Fire Company Database
Preview
Preparation
Background
Assignment 1: Creating the Database Design
Assignment 2: Creating the Database, Forms, Queries, and Report
Deliverables
Part 2: Decision Support Cases Using Microsoft Excel Scenario Manager
Tutorial C: Building a Decision Support System in Excel
Spreadsheet and DSS Basics
Using Scenario Manager
Practicing with Scenario Manager
Reviewing Excel Basics
Case 6: The Ski Resort Investment Decision
Preview
Preparation
Background
Assignment 1: Creating a Spreadsheet for Decision Support
Assignment 2: Using the Spreadsheet for Decision Support
Deliverables
Case 7: The College Town Budget
Preview
Preparation
Background
Assignment 1: Creating a Spreadsheet for Decision Support
Assignment 2: Using the Spreadsheet for Decision Support
Deliverables
Part 3: Decision Support Cases Using Microsoft Excel Solver
Tutorial D: Building a Decision Support System Using Microsoft Excel Solver
Using Excel Solver
Extending the Example
Using Solver on a New Problem
Troubleshooting Solver
Case 8: Rose Tree Regional Airline
Preview
Preparation
Background
Assignment 1: Creating Spreadsheet Models for Decision Support
Assignment 2: Using the Workbook for Decision Support
Assignment 3: Giving an Oral Presentation
Deliverables
Case 9: The Auto Maker Product Mix Problem
Preview
Preparation
Background
Assignment 1: Creating a Spreadsheet for Decision Support
Assignment 2: Using the Spreadsheet for Decision Support
Deliverables
Part 4: Integration Cases Using Microsoft Access and Excel
Case 10: The Donation Letter Analysis
Preview
Preparation
Background
Assignment 1: Using Access and Excel for Decision Support
Assignment 2: Documenting the Findings in a Memo
Deliverables
Case 11: San Francisco Fire Incidents
Preview
Preparation
Background
Assignment 1: Using Access for Data Inspection
Assignment 2: Using Access for Data Analysis
Assignment 3: Importing Data into Excel for Further Analysis
Assignment 4: Documenting Your Findings in a Memo
Deliverables
Case 12: San Francisco Fire Incidents: Advanced Analysis
Preview
Preparation
Background
Assignment 1: Using Access for Data Inspection
Assignment 2: Using Access to Create the Analytical Database
Assignment 3: Importing Data into Excel for Further Analysis
Assignment 4: Documenting Your Findings in a Memo
Deliverables
Part 5: Advanced Skills Using Microsoft Excel
Tutorial E: Guidance for Excel Cases
Preparing a Memorandum in Word
Entering a Table into a Word Document
Data Tables
Pivot Tables
Built-in Functions
Index