Succeeding in Business TM with Microsoft Access 2013 A Problem Solving Approach 1st edition by Sandra Cable ISBN 128507758X 978-1285077581

Succeeding in Business with Microsoft(r) Access(r) 2013: A Problem Solving Approach 1st edition by Sandra Cable – Ebook PDF Instant Download/Delivery:  128507758X  , 978-1285077581
Full download Succeeding in Business with Microsoft(r) Access(r) 2013: A Problem Solving Approach 1st edition after payment

Product details:

ISBN 10: 128507758X

ISBN 13: 978-1285077581

Author: Sandra Cable

SUCCEEDING IN BUSINESS WITH MICROSOFT ACCESS 2013 prepares your students to solve business problems by moving beyond the basic “point and click” skills to think critically about realistic business situations. When students combine software analysis with their own decision making abilities, they are more likely meet any business challenge with success. The Succeeding in Business Series emphasizes problem-solving, critical thinking, and analysis – challenging students to find efficient and effective solutions.

Succeeding in BusinessTM with Microsoft(r) Access(r) 2013: A Problem Solving Approach 1st Table of contents:

Ch 1: Applying Fundamental Excel Skills and Tools in Problem Solving: Finance: Analyzing Costs and P

Ch 1: Learning Objectives

Ch 1: Functions Covered in This Chapter

Ch 1: Chapter Introduction

Ch 1: Case Scenario

Level 1: Identifying and Correcting Common Errors in Formatting and Formulas

Examining a Basic Worksheet for Errors

Correcting Formatting Problems

Correcting Errors in Formulas

Level 2: Calculating and Comparing Data Using Simple Functions

Working with Multiple Worksheets

Calculating Totals Using the SUM Function

Calculating Average, Minimum, and Maximum Values

Calculating the Number of Values Using the COUNT and COUNTA Functions

Level 3: Analyzing Cell References When Writing and Copying Formulas

Creating a Budget Workbook

Understanding Relative Cell Referencing

Understanding Absolute and Mixed Cell Referencing

Ch 1: Chapter Summary

Ch 1: Conceptual Review

Ch 1: Case Problems

Ch 2: Solving Problems with Statistical Analysis Tools: Manufacturing: Evaluating Quality Control Da

Ch 2: Learning Objectives

Ch 2: Functions Covered in This Chapter

Ch 2: Chapter Introduction

Ch 2: Case Scenario

Level 1: Using Statistical Functions to Compare Data Values

Understanding the Fundamentals of Statistics

Controlling the Precision of Data Using the ROUND Function

Using Paste Special to Copy and Paste Data

Calculating the Mean, Median, Mode, and Standard Deviation

Managing Large Worksheets by Freezing Panes and Splitting the Window

Comparing Current Values with Historical Values

Level 2: Organizing and Evaluating Different Data Groupings

Quick Insertion of Aggregate Values for a Data Set

Determining a Rank for Each Value in a Data Set

Determining the Highest and Lowest Values in a Data Set

Determining the Number of Items That Meet Specified Criteria

Determining a Total Value for Items That Meet Specified Criteria

Level 3: Extending the Analysis with What-If, Goal Seek, and Simulation

Evaluating a Larger Data Set

Specifying a Custom Number Format

Considering Alternatives: What-If Analysis and Goal Seek

Combining COUNTIF and AVERAGEIF to Analyze Data in Specific Categories

Analyzing Data Through Simulation

Ch 2: Chapter Summary

Ch 2: Conceptual Review

Ch 2: Case Problems

Ch 3: Determining Effective Data Display with Charts: Marketing: Analyzing Trends in the Sporting Go

Ch 3: Learning Objectives

Chart Types Covered in This Chapter

Ch 3: Chapter Introduction

Ch 3: Case Scenario

Level 1: Visualizing Data

Effective Data Display

Effective Charting in Excel

Level 2: Evaluating Chart Sub-Types

Examining Sub-Types for Various Chart Types

Level 3: Exploring More Advanced Chart Types

Evaluating the Effectiveness of Radar, Bubble, and Dashboard Charts

Ch 3: Chapter Summary

Ch 3: Conceptual Review

Ch 3: Case Problems

Ch 4: Applying Logic in Decision Making: Accounting: Establishing a Credit Approval Process for Acco

Ch 4: Learning Objectives

Ch 4: Functions Covered in This Chapter

Ch 4: Chapter Introduction

Ch 4: Case Scenario

Level 1: Analyzing Data Using Relational Operators and Boolean Logical Functions

Reviewing Financial Criteria Related to Credit

Using Relational Operators to Compare Two Values

Using Boolean Logical Functions to Evaluate a List of Values and Determine a Single TRUE or FALSE Va

Applying Conditional Formatting to a Worksheet

Level 2: Analyzing Data Using IF Functions and Nested Functions

Introduction to IF Functions and Nested Functions

Writing Simple IF Functions

Writing IF Functions with Nested Functions

Constructing a Simple Nested IF Function

Level 3: Creating Complex Logical Constructs for Solving Problems

Evaluating More Complex Criteria

Using an IF Function to Combine Sets of Criteria

Using the None Of Construct

Using the Only Construct

Completing the Complex Nested IF Formula

Ch 4: Chapter Summary

Ch 4: Conceptual Review

Ch 4: Case Problems

Ch 5: Retrieving Data for Computation, Analysis, and Reference: Sales: Creating Product Order Forms

Ch 5: Learning Objectives

Ch 5: Functions Covered in This Chapter

Ch 5: Chapter Introduction

Ch 5: Case Scenario

Level 1: Performing Basic Lookups to Calculate and Evaluate Data

Working with Lookup Tables

Retrieving Data from a Vertical Lookup Table

Retrieving Data from a Horizontal Lookup Table

Level 2: Performing More Complex Lookups Involving Multiple Worksheets and Multidimensional Tables

Retrieving Data from Multiple Worksheets

Looking Up Data in a One-Row or One-Column Range

Retrieving Data from Multidimensional Tables

Level 3: Nesting Lookup and Reference Functions to Retrieve and Calculate Data

Refining the Order Form

Preventing Errors in Data Retrieval

Nesting LOOKUP and IF Functions to Calculate the Price per Unit

Calculating Totals

Calculating the Discount Amount

Calculating the Shipping Costs Using MATCH and INDEX Functions

Ch 5: Chapter Summary

Ch 5: Conceptual Review

Ch 5: Case Problems

Ch 6: Evaluating the Financial Impact of Loans and Investments: Finance: Forecasting Cash Flows for

Ch 6: Learning Objectives

Ch 6: Functions Covered in This Chapter

Ch 6: Chapter Introduction

Ch 6: Case Scenario

Level 1: Calculating Values for Simple Financial Transactions

Understanding How Interest Is Calculated

Reviewing Alternative Financing Options

Using the PMT Function to Determine a Loan Payment

Using the RATE, NPER, PV, and FV Functions

Selecting a Financing Option

Level 2: Creating a Projected Cash Flow Estimate and Amortization Schedule

Designing a Worksheet to Estimate Cash Flow

Setting Up an Amortization Schedule

Calculating Depreciation Using the SLN Function

Calculating Taxes

Level 3: Evaluating the Financial Viability of Alternative Project Options

Setting Up a Worksheet to Analyze Profitability

Calculating Net Present Value

Calculating the Internal Rate of Return

Calculating the Return on Investment

Determining the Payback Period

Setting Up the Worksheet for the Low Capital Option

Evaluating the Results of the Analysis

Ch 6: Chapter Summary

Ch 6: Conceptual Review

Ch 6: Case Problems

Ch 7: Organizing Data for Effective Analysis: Marketing: Transforming Raw Data into Various Formats

Ch 7: Learning Objectives

Ch 7: Functions Covered in This Chapter

Ch 7: Chapter Introduction

Ch 7: Case Scenario

Level 1: Importing and Structuring Text Data in Excel Worksheets

Working with Text Data

Combining Text Using the CONCATENATE Function

Extracting Characters from a Text String

Converting Text into Columns of Data

Analyzing Data by Creating Subtotals

Creating and Working with an Excel Table

Level 2: Analyzing Data Imported from a Database and Organizing Data with a PivotTable Report

Importing Data from a Database into Excel

Making Calculations with Date and Time Data

Analyzing Data Using a PivotTable Report

Evaluating Data Using a PivotChart Report

Level 3: Importing and Exporting XML Data

Understanding Markup Languages and XML

Analyzing XML Data with Excel

Importing XML Data as an XML Table

Adding an XML Map to a Workbook

Exporting XML Data

Ch 7: Chapter Summary

Ch 7: Conceptual Review

Ch 7: Case Problems

Ch 8: Using Data Tables and Excel Scenarios for What-If Analysis: Marketing: Analyzing the Profitabi

Ch 8: Learning Objectives

Ch 8: Tools/Functions Covered in This Chapter

Ch 8: Chapter Introduction

Ch 8: Case Scenario

Level 1: Using Data Tables to Perform Break-Even and Sensitivity Analyses

Conducting Break-Even and Sensitivity Analyses

Analyzing What-If Results with Data Tables

Varying One Value in a What-If Analysis

Varying Two Values in a What-If Analysis

Level 2: Using Scenarios to Perform What-If Analysis

Comparing the Results of Complex Analyses

Planning Scenarios

Adding Scenarios to a Worksheet

Generating Scenario Reports

Level 3: Using Excel’s Data Tables to Create a Simulation

Understanding Simulation in Business

Preparing a Worksheet for a Simulation Using a Data Table

Developing a Simulation with a Two-Variable Data Table

Calculating Simulation Statistics

Interpreting Simulation Results

Ch 8: Chapter Summary

Ch 8: Conceptual Review

Ch 8: Case Problems

Ch 9: Enhancing Decision Making with Solver: Operations Management: Developing Solver Models to Allo

Ch 9: Learning Objectives

Ch 9: Tools/Functions Covered in This Chapter

Ch 9: Chapter Introduction

Ch 9: Case Scenario

Level 1: Solving Product Mix Questions Using Goal Seek and Solver

The Other Side of What-If Analysis

Performing What-If Analysis Using Goal Seek

Creating a Solver Model

Level 2: Enhancing the Production Plan with Solver

Adding Time Variables to the Production Plan

Level 3: Managing Transportation Problems with Solver

Developing a Distribution Plan Using Solver

Assigning Contracts by Using Binary Constraints

Ch 9: Chapter Summary

Ch 9: Conceptual Review

Ch 9: Case Problems

Ch 10: Troubleshooting Workbooks and Automating Excel Applications: Accounting: Creating Automated I

Ch 10: Learning Objectives

Tools Covered in This Chapter

Ch 10: Chapter Introduction

Ch 10: Case Scenario

Level 1: Preparing Error-Free Workbooks

Planning an Excel Application

Controlling Data-Entry Errors Using the Data Validation Tool

Protecting Workbooks

Documenting Workbooks

Level 2: Identifying and Correcting Formula Errors

Types of Formula Errors

Tools for Solving Formula Errors

Tracing and Solving Formula Errors

Level 3: Automating Excel Tasks

Defining Macros

Creating a Macro

Running a Macro

Viewing a Macro in the Visual Basic Editor

Ch 10: Chapter Summary

Ch 10: Conceptual Review

Ch 10: Case Problems

People also search for Succeeding in BusinessTM with Microsoft(r) Access(r) 2013: A Problem Solving Approach 1st:

succeeding in businesstm with microsoft(r) access

ms access business

microsoft access f10

microsoft access guid

ms access richard rost

Tags:

Sandra Cable,Succeeding in BusinessTM,A Problem