Questions About This Book?
Why should I rent this book?
How do rental returns work?
What version or edition is this?
What is included with this book?
- The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any CDs, lab manuals, study guides, etc.
- The Rental copy of this book is not guaranteed to include any supplemental materials. You may receive a brand new copy, but typically, only the book itself.
- The eBook copy of this book is not guaranteed to include any supplemental materials. Typically only the book itself is included.
Amy holds a B.A. degree in Chemistry with a Business minor and a J.D. from the Maurer School of Law both at Indiana University. After working as an environmental chemist, starting her own technology consulting company, and practicing intellectual property law, she has spent the past eleven years teaching technology at the Kelley School of Business in Bloomington, Indiana. Currently, she serves as the Director of Computer Skills and Senior Lecturer at the Kelley School of Business at Indiana University. She also loves spending time with her two sons, Aidan and J. Matthew, and her husband J. Eric.
Table of Contents
Advanced Problems Module 1
Workshop 1 : Business Problem Solving
Prepare Case: Golf Nook Clothing Store Sales, Inventory and Customer Analysis
Define the Business Problem
Planning Steps to Solve the Problem
To Create the Relationships
Creating the Queries
To Create Queries of Month’s Sales
To Create Query of Total Month’s Sales
To Create Query of Current Inventory
To Create Query of Cumulative Sales
To Create Query of Starting Inventory
To Combine Queries to Compute Percentage
To Create a Query of Percentage of Starting Inventory Sold
Exporting Data to Excel for Analysis and Charting
Analysis and Charting
Create a Report of the Problem Solution
To Complete the Sales Analysis Report
Analysis Presentation of Recommended Action
To Create the Presentation Based on the Sales Analysis Report
To Create Query of Annual Demand by Product
To Create Query of Annual Sales by Product
To Export Data to Excel for Analysis and Calculations
To Complete the Inventory Analysis Report
To Create the Presentation Based on the Inventory Analysis Report
To Create Query of Customers That Have Made a Purchase
To Create Query of Customers That Have Not Made a Purchase
To Create Query of Customers and their E-mails
To Create Query of Customers That Have Made a Popular Product Purchase
To Create Query of Customers That Have Not Made a Popular Product Purchase
To Create E-mail Messages to Customers That Have Not Made a Purchase
To Create Letters to Customers That Have Not Made a Purchase
To Complete the Customer Analysis Report
To Create the Presentation Based on the Customer Analysis Report
Problem Solve Case 1
Perform in your Career
Perform in your Career