Problem Solving Cases In Microsoft Access & Excel

by Ellen Monk, Emilio Mendelsohn, Joseph Brady

Length: 256 pages
Edition: 1
Language: English
Publisher: Cengage Learning
Publication Date: 2019-07-19
ISBN-10: 0357138635
ISBN-13: 9780357138632
Sales Rank: #373718 (See Top 100 Books)

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.

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