Solution Manual for Your Office: Getting Started with Advanced Cases for Microsoft Office 2010 : 0132675498

A Comprehensive Solution Manual for Your Office: Getting Started with Advanced Cases for Microsoft Office 2010 By Barry Walker, et al,

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
Problem Definition
To Create the Relationships
Creating the Queries
Information Requirements
To Create Queries of Month’s Sales
Intrinsic Functions
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
Inventory Analysis
Problem Definition
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
Analysis Report
To Complete the Inventory Analysis Report
Analysis Presentation
To Create the Presentation Based on the Inventory Analysis Report
Customer Analysis
Problem Definition
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
Concept Check
Key Terms
Visual Summary
Problem Solve
Problem Solve Case 1
Perform
Perform in your Career