Cart subtotal (0 items): $0.00
Problem Solving Cases In Microsoft Access & Excel

PROBLEM SOLVING CASES IN MICRO SOFT ACCESS & EXCEL

Problem Solving Cases In Microsoft Access & Excel
Edition
16
Pub Date
2019-07-19
Copyright Year
2020
ISBN10
0357138635
ISBN13
9780357138632
Publisher
Course Technology
Page Count
0
Dimensions
8.56 in
10.88 in
0.38 in
Binding Format
Soft Cover
Units Per Carton
20.00
In Cart
$115.96
(Retail price: $144.95)
(You save $28.99 )
Ships in 1-3 business days
Add to Cart Adding to cart… Added to cart
 
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.
  • TIMELY UPDATES THROUGHOUT THIS EDITION REFLECT THE LATEST CHANGES IN MICROSOFT® OFFICE 2019. The most recent information on Access and Excel, integrated throughout this edition, equips you to present the latest database and spreadsheet tools. Demonstrate how students can maximize the new software advantages as content highlights the most recent changes in MS Office.
  • TIMELY UPDATES THROUGHOUT THIS EDITION REFLECT THE LATEST CHANGES IN MICROSOFT® OFFICE 2019. The most recent information on Access and Excel, integrated throughout this edition, equips you to present the latest database and spreadsheet tools. Demonstrate how students can maximize the new software advantages as content highlights the most recent changes in MS Office.
  • AN UPDATED DATA ANALYTICS TUTORIAL PREPARES STUDENTS TO ANALYZE AND APPLY TODAY'S DATA. Students learn how to collect, organize and examine large amounts of raw data effectively in order to identify significant patterns and draw meaningful conclusions.
  • AN UPDATED DATA ANALYTICS TUTORIAL PREPARES STUDENTS TO ANALYZE AND APPLY TODAY'S DATA. Students learn how to collect, organize and examine large amounts of raw data effectively in order to identify significant patterns and draw meaningful conclusions.
  • COVERAGE HIGHLIGHTS POWERFUL EXCEL ADD-INS AND CAPABILITIES. Students strengthen their data analysis skills as they learn to use Power Queries Excel add-in to extract data from many sources. Students work with data cubes that lets users explore and analyze data from a variety of perspectives and learn to use the PowerPivot add-in for powerful data analytics with data from multiple sources.
  • COVERAGE HIGHLIGHTS POWERFUL EXCEL ADD-INS AND CAPABILITIES. Students strengthen their data analysis skills as they learn to use Power Queries Excel add-in to extract data from many sources. Students work with data cubes that lets users explore and analyze data from a variety of perspectives and learn to use the PowerPivot add-in for powerful data analytics with data from multiple sources.
  • UPDATED SCENARIO MANAGER AND SOLVER TUTORIALS DEMONSTRATE KEY TOOLS WITHIN EXCEL. Timely tutorials introduce these powerful features available in Excel and explain how students can maximize the tools to solve important business challenges.
  • UPDATED SCENARIO MANAGER AND SOLVER TUTORIALS DEMONSTRATE KEY TOOLS WITHIN EXCEL. Timely tutorials introduce these powerful features available in Excel and explain how students can maximize the tools to solve important business challenges.
  • AUTHENTIC BUSINESS SCENARIOS BLEND EXCEL AND ACCESS PRACTICE. Each of this edition’s 12 new cases introduces a commonly occurring business issue, giving students hands-on experience using Excel and Access to analyze and solve relevant problems.
  • AUTHENTIC BUSINESS SCENARIOS BLEND EXCEL AND ACCESS PRACTICE. Each of this edition’s 12 new cases introduces a commonly occurring business issue, giving students hands-on experience using Excel and Access to analyze and solve relevant problems.
  • CLEAR SKILL-BUILDING INSTRUCTION DEMONSTRATES HOW TO USE MICROSOFT® ACCESS AND EXCEL 2019 MOST EFFECTIVELY. Hands-on tutorials prepare your students for success in today’s workplace by helping them develop critical spreadsheet and database skills.
  • CLEAR SKILL-BUILDING INSTRUCTION DEMONSTRATES HOW TO USE MICROSOFT® ACCESS AND EXCEL 2019 MOST EFFECTIVELY. Hands-on tutorials prepare your students for success in today’s workplace by helping them develop critical spreadsheet and database skills.
  • EMPHASIS ON DATA ANALYSIS TECHNIQUES REFINES STUDENTS' UNDERSTANDING OF EXCEL. This edition introduces your students to more complex uses of Excel spreadsheets, deepening their understanding of the software and its capabilities in business today.
  • EMPHASIS ON DATA ANALYSIS TECHNIQUES REFINES STUDENTS' UNDERSTANDING OF EXCEL. This edition introduces your students to more complex uses of Excel spreadsheets, deepening their understanding of the software and its capabilities in business today.
  • INTEGRATION CASES WALK STUDENTS THROUGH HOW TO WORK WITH ACCESS AND EXCEL TOGETHER. Two cases require students to apply both Access and Excel simultaneously, helping readers see first-hand how the programs can share data and complement each application's strengths.
  • INTEGRATION CASES WALK STUDENTS THROUGH HOW TO WORK WITH ACCESS AND EXCEL TOGETHER. Two cases require students to apply both Access and Excel simultaneously, helping readers see first-hand how the programs can share data and complement each application's strengths.
  • STUDENTS REFINE PRESENTATION SKILLS THAT ARE IMPORTANT IN BUSINESS TODAY. An additional online tutorial provides insights and guidance designed to help students master the art of effective business presentations.
  • STUDENTS REFINE PRESENTATION SKILLS THAT ARE IMPORTANT IN BUSINESS TODAY. An additional online tutorial provides insights and guidance designed to help students master the art of effective business presentations.
  • Part I: DATABASE CASES USING ACCESS.
  • Tutorial A. Database Design.
  • Tutorial B. Microsoft Access.
  • Case 1. Preliminary Case: Dog Hikes.
  • Case 2. The Parks and Recreation Database.
  • Case 3. The Senior Concierge Database.
  • Case 4. The Fresh Fish Database.
  • Case 5. The Volunteer Fire Company Database
  • Part II: DECISION SUPPORT CASES USING MICROSOFT EXCEL SCENARIO MANAGER.
  • Tutorial C. Building a Decision Support Systems in Excel.
  • Case 6. The Ski Resort Investment Decision.
  • Case 7. The College Town Budget.
  • Part III: DECISION SUPPORT CASES USING MICROSOFT EXCEL SOLVER.
  • Tutorial D. Building a Decision Support System Using Microsoft Excel Solver.
  • Case 8. Rose Tree Regional Airline.
  • Case 9. The Auto Maker Product Mix Problem.
  • Part IV: DECISION SUPPORT CASE USING BASIC ACCESS AND EXCEL FUNCTIONALITY.
  • Case 10. The Donation Letter Analysis.
  • Part V: INTEGRATION CASES USING MICROSOFT ACCESS AND EXCEL.
  • Case 11. San Francisco Fire Incidents.
  • Case 12. San Francisco Fire Incidents: Advanced Analysis.
  • Part VI: ADVANCED SKILLS USING EXCEL.
  • Tutorial E. Guidance for Excel Cases.
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.
  • TIMELY UPDATES THROUGHOUT THIS EDITION REFLECT THE LATEST CHANGES IN MICROSOFT® OFFICE 2019. The most recent information on Access and Excel, integrated throughout this edition, equips you to present the latest database and spreadsheet tools. Demonstrate how students can maximize the new software advantages as content highlights the most recent changes in MS Office.
  • TIMELY UPDATES THROUGHOUT THIS EDITION REFLECT THE LATEST CHANGES IN MICROSOFT® OFFICE 2019. The most recent information on Access and Excel, integrated throughout this edition, equips you to present the latest database and spreadsheet tools. Demonstrate how students can maximize the new software advantages as content highlights the most recent changes in MS Office.
  • AN UPDATED DATA ANALYTICS TUTORIAL PREPARES STUDENTS TO ANALYZE AND APPLY TODAY'S DATA. Students learn how to collect, organize and examine large amounts of raw data effectively in order to identify significant patterns and draw meaningful conclusions.
  • AN UPDATED DATA ANALYTICS TUTORIAL PREPARES STUDENTS TO ANALYZE AND APPLY TODAY'S DATA. Students learn how to collect, organize and examine large amounts of raw data effectively in order to identify significant patterns and draw meaningful conclusions.
  • COVERAGE HIGHLIGHTS POWERFUL EXCEL ADD-INS AND CAPABILITIES. Students strengthen their data analysis skills as they learn to use Power Queries Excel add-in to extract data from many sources. Students work with data cubes that lets users explore and analyze data from a variety of perspectives and learn to use the PowerPivot add-in for powerful data analytics with data from multiple sources.
  • COVERAGE HIGHLIGHTS POWERFUL EXCEL ADD-INS AND CAPABILITIES. Students strengthen their data analysis skills as they learn to use Power Queries Excel add-in to extract data from many sources. Students work with data cubes that lets users explore and analyze data from a variety of perspectives and learn to use the PowerPivot add-in for powerful data analytics with data from multiple sources.
  • UPDATED SCENARIO MANAGER AND SOLVER TUTORIALS DEMONSTRATE KEY TOOLS WITHIN EXCEL. Timely tutorials introduce these powerful features available in Excel and explain how students can maximize the tools to solve important business challenges.
  • UPDATED SCENARIO MANAGER AND SOLVER TUTORIALS DEMONSTRATE KEY TOOLS WITHIN EXCEL. Timely tutorials introduce these powerful features available in Excel and explain how students can maximize the tools to solve important business challenges.
  • AUTHENTIC BUSINESS SCENARIOS BLEND EXCEL AND ACCESS PRACTICE. Each of this edition’s 12 new cases introduces a commonly occurring business issue, giving students hands-on experience using Excel and Access to analyze and solve relevant problems.
  • AUTHENTIC BUSINESS SCENARIOS BLEND EXCEL AND ACCESS PRACTICE. Each of this edition’s 12 new cases introduces a commonly occurring business issue, giving students hands-on experience using Excel and Access to analyze and solve relevant problems.
  • CLEAR SKILL-BUILDING INSTRUCTION DEMONSTRATES HOW TO USE MICROSOFT® ACCESS AND EXCEL 2019 MOST EFFECTIVELY. Hands-on tutorials prepare your students for success in today’s workplace by helping them develop critical spreadsheet and database skills.
  • CLEAR SKILL-BUILDING INSTRUCTION DEMONSTRATES HOW TO USE MICROSOFT® ACCESS AND EXCEL 2019 MOST EFFECTIVELY. Hands-on tutorials prepare your students for success in today’s workplace by helping them develop critical spreadsheet and database skills.
  • EMPHASIS ON DATA ANALYSIS TECHNIQUES REFINES STUDENTS' UNDERSTANDING OF EXCEL. This edition introduces your students to more complex uses of Excel spreadsheets, deepening their understanding of the software and its capabilities in business today.
  • EMPHASIS ON DATA ANALYSIS TECHNIQUES REFINES STUDENTS' UNDERSTANDING OF EXCEL. This edition introduces your students to more complex uses of Excel spreadsheets, deepening their understanding of the software and its capabilities in business today.
  • INTEGRATION CASES WALK STUDENTS THROUGH HOW TO WORK WITH ACCESS AND EXCEL TOGETHER. Two cases require students to apply both Access and Excel simultaneously, helping readers see first-hand how the programs can share data and complement each application's strengths.
  • INTEGRATION CASES WALK STUDENTS THROUGH HOW TO WORK WITH ACCESS AND EXCEL TOGETHER. Two cases require students to apply both Access and Excel simultaneously, helping readers see first-hand how the programs can share data and complement each application's strengths.
  • STUDENTS REFINE PRESENTATION SKILLS THAT ARE IMPORTANT IN BUSINESS TODAY. An additional online tutorial provides insights and guidance designed to help students master the art of effective business presentations.
  • STUDENTS REFINE PRESENTATION SKILLS THAT ARE IMPORTANT IN BUSINESS TODAY. An additional online tutorial provides insights and guidance designed to help students master the art of effective business presentations.
  • Part I: DATABASE CASES USING ACCESS.
  • Tutorial A. Database Design.
  • Tutorial B. Microsoft Access.
  • Case 1. Preliminary Case: Dog Hikes.
  • Case 2. The Parks and Recreation Database.
  • Case 3. The Senior Concierge Database.
  • Case 4. The Fresh Fish Database.
  • Case 5. The Volunteer Fire Company Database
  • Part II: DECISION SUPPORT CASES USING MICROSOFT EXCEL SCENARIO MANAGER.
  • Tutorial C. Building a Decision Support Systems in Excel.
  • Case 6. The Ski Resort Investment Decision.
  • Case 7. The College Town Budget.
  • Part III: DECISION SUPPORT CASES USING MICROSOFT EXCEL SOLVER.
  • Tutorial D. Building a Decision Support System Using Microsoft Excel Solver.
  • Case 8. Rose Tree Regional Airline.
  • Case 9. The Auto Maker Product Mix Problem.
  • Part IV: DECISION SUPPORT CASE USING BASIC ACCESS AND EXCEL FUNCTIONALITY.
  • Case 10. The Donation Letter Analysis.
  • Part V: INTEGRATION CASES USING MICROSOFT ACCESS AND EXCEL.
  • Case 11. San Francisco Fire Incidents.
  • Case 12. San Francisco Fire Incidents: Advanced Analysis.
  • Part VI: ADVANCED SKILLS USING EXCEL.
  • Tutorial E. Guidance for Excel Cases.
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.
  • TIMELY UPDATES THROUGHOUT THIS EDITION REFLECT THE LATEST CHANGES IN MICROSOFT® OFFICE 2019. The most recent information on Access and Excel, integrated throughout this edition, equips you to present the latest database and spreadsheet tools. Demonstrate how students can maximize the new software advantages as content highlights the most recent changes in MS Office.
  • TIMELY UPDATES THROUGHOUT THIS EDITION REFLECT THE LATEST CHANGES IN MICROSOFT® OFFICE 2019. The most recent information on Access and Excel, integrated throughout this edition, equips you to present the latest database and spreadsheet tools. Demonstrate how students can maximize the new software advantages as content highlights the most recent changes in MS Office.
  • AN UPDATED DATA ANALYTICS TUTORIAL PREPARES STUDENTS TO ANALYZE AND APPLY TODAY'S DATA. Students learn how to collect, organize and examine large amounts of raw data effectively in order to identify significant patterns and draw meaningful conclusions.
  • AN UPDATED DATA ANALYTICS TUTORIAL PREPARES STUDENTS TO ANALYZE AND APPLY TODAY'S DATA. Students learn how to collect, organize and examine large amounts of raw data effectively in order to identify significant patterns and draw meaningful conclusions.
  • COVERAGE HIGHLIGHTS POWERFUL EXCEL ADD-INS AND CAPABILITIES. Students strengthen their data analysis skills as they learn to use Power Queries Excel add-in to extract data from many sources. Students work with data cubes that lets users explore and analyze data from a variety of perspectives and learn to use the PowerPivot add-in for powerful data analytics with data from multiple sources.
  • COVERAGE HIGHLIGHTS POWERFUL EXCEL ADD-INS AND CAPABILITIES. Students strengthen their data analysis skills as they learn to use Power Queries Excel add-in to extract data from many sources. Students work with data cubes that lets users explore and analyze data from a variety of perspectives and learn to use the PowerPivot add-in for powerful data analytics with data from multiple sources.
  • UPDATED SCENARIO MANAGER AND SOLVER TUTORIALS DEMONSTRATE KEY TOOLS WITHIN EXCEL. Timely tutorials introduce these powerful features available in Excel and explain how students can maximize the tools to solve important business challenges.
  • UPDATED SCENARIO MANAGER AND SOLVER TUTORIALS DEMONSTRATE KEY TOOLS WITHIN EXCEL. Timely tutorials introduce these powerful features available in Excel and explain how students can maximize the tools to solve important business challenges.
  • AUTHENTIC BUSINESS SCENARIOS BLEND EXCEL AND ACCESS PRACTICE. Each of this edition’s 12 new cases introduces a commonly occurring business issue, giving students hands-on experience using Excel and Access to analyze and solve relevant problems.
  • AUTHENTIC BUSINESS SCENARIOS BLEND EXCEL AND ACCESS PRACTICE. Each of this edition’s 12 new cases introduces a commonly occurring business issue, giving students hands-on experience using Excel and Access to analyze and solve relevant problems.
  • CLEAR SKILL-BUILDING INSTRUCTION DEMONSTRATES HOW TO USE MICROSOFT® ACCESS AND EXCEL 2019 MOST EFFECTIVELY. Hands-on tutorials prepare your students for success in today’s workplace by helping them develop critical spreadsheet and database skills.
  • CLEAR SKILL-BUILDING INSTRUCTION DEMONSTRATES HOW TO USE MICROSOFT® ACCESS AND EXCEL 2019 MOST EFFECTIVELY. Hands-on tutorials prepare your students for success in today’s workplace by helping them develop critical spreadsheet and database skills.
  • EMPHASIS ON DATA ANALYSIS TECHNIQUES REFINES STUDENTS' UNDERSTANDING OF EXCEL. This edition introduces your students to more complex uses of Excel spreadsheets, deepening their understanding of the software and its capabilities in business today.
  • EMPHASIS ON DATA ANALYSIS TECHNIQUES REFINES STUDENTS' UNDERSTANDING OF EXCEL. This edition introduces your students to more complex uses of Excel spreadsheets, deepening their understanding of the software and its capabilities in business today.
  • INTEGRATION CASES WALK STUDENTS THROUGH HOW TO WORK WITH ACCESS AND EXCEL TOGETHER. Two cases require students to apply both Access and Excel simultaneously, helping readers see first-hand how the programs can share data and complement each application's strengths.
  • INTEGRATION CASES WALK STUDENTS THROUGH HOW TO WORK WITH ACCESS AND EXCEL TOGETHER. Two cases require students to apply both Access and Excel simultaneously, helping readers see first-hand how the programs can share data and complement each application's strengths.
  • STUDENTS REFINE PRESENTATION SKILLS THAT ARE IMPORTANT IN BUSINESS TODAY. An additional online tutorial provides insights and guidance designed to help students master the art of effective business presentations.
  • STUDENTS REFINE PRESENTATION SKILLS THAT ARE IMPORTANT IN BUSINESS TODAY. An additional online tutorial provides insights and guidance designed to help students master the art of effective business presentations.
  • Part I: DATABASE CASES USING ACCESS.
  • Tutorial A. Database Design.
  • Tutorial B. Microsoft Access.
  • Case 1. Preliminary Case: Dog Hikes.
  • Case 2. The Parks and Recreation Database.
  • Case 3. The Senior Concierge Database.
  • Case 4. The Fresh Fish Database.
  • Case 5. The Volunteer Fire Company Database
  • Part II: DECISION SUPPORT CASES USING MICROSOFT EXCEL SCENARIO MANAGER.
  • Tutorial C. Building a Decision Support Systems in Excel.
  • Case 6. The Ski Resort Investment Decision.
  • Case 7. The College Town Budget.
  • Part III: DECISION SUPPORT CASES USING MICROSOFT EXCEL SOLVER.
  • Tutorial D. Building a Decision Support System Using Microsoft Excel Solver.
  • Case 8. Rose Tree Regional Airline.
  • Case 9. The Auto Maker Product Mix Problem.
  • Part IV: DECISION SUPPORT CASE USING BASIC ACCESS AND EXCEL FUNCTIONALITY.
  • Case 10. The Donation Letter Analysis.
  • Part V: INTEGRATION CASES USING MICROSOFT ACCESS AND EXCEL.
  • Case 11. San Francisco Fire Incidents.
  • Case 12. San Francisco Fire Incidents: Advanced Analysis.
  • Part VI: ADVANCED SKILLS USING EXCEL.
  • Tutorial E. Guidance for Excel Cases.
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.
  • TIMELY UPDATES THROUGHOUT THIS EDITION REFLECT THE LATEST CHANGES IN MICROSOFT® OFFICE 2019. The most recent information on Access and Excel, integrated throughout this edition, equips you to present the latest database and spreadsheet tools. Demonstrate how students can maximize the new software advantages as content highlights the most recent changes in MS Office.
  • TIMELY UPDATES THROUGHOUT THIS EDITION REFLECT THE LATEST CHANGES IN MICROSOFT® OFFICE 2019. The most recent information on Access and Excel, integrated throughout this edition, equips you to present the latest database and spreadsheet tools. Demonstrate how students can maximize the new software advantages as content highlights the most recent changes in MS Office.
  • AN UPDATED DATA ANALYTICS TUTORIAL PREPARES STUDENTS TO ANALYZE AND APPLY TODAY'S DATA. Students learn how to collect, organize and examine large amounts of raw data effectively in order to identify significant patterns and draw meaningful conclusions.
  • AN UPDATED DATA ANALYTICS TUTORIAL PREPARES STUDENTS TO ANALYZE AND APPLY TODAY'S DATA. Students learn how to collect, organize and examine large amounts of raw data effectively in order to identify significant patterns and draw meaningful conclusions.
  • COVERAGE HIGHLIGHTS POWERFUL EXCEL ADD-INS AND CAPABILITIES. Students strengthen their data analysis skills as they learn to use Power Queries Excel add-in to extract data from many sources. Students work with data cubes that lets users explore and analyze data from a variety of perspectives and learn to use the PowerPivot add-in for powerful data analytics with data from multiple sources.
  • COVERAGE HIGHLIGHTS POWERFUL EXCEL ADD-INS AND CAPABILITIES. Students strengthen their data analysis skills as they learn to use Power Queries Excel add-in to extract data from many sources. Students work with data cubes that lets users explore and analyze data from a variety of perspectives and learn to use the PowerPivot add-in for powerful data analytics with data from multiple sources.
  • UPDATED SCENARIO MANAGER AND SOLVER TUTORIALS DEMONSTRATE KEY TOOLS WITHIN EXCEL. Timely tutorials introduce these powerful features available in Excel and explain how students can maximize the tools to solve important business challenges.
  • UPDATED SCENARIO MANAGER AND SOLVER TUTORIALS DEMONSTRATE KEY TOOLS WITHIN EXCEL. Timely tutorials introduce these powerful features available in Excel and explain how students can maximize the tools to solve important business challenges.
  • AUTHENTIC BUSINESS SCENARIOS BLEND EXCEL AND ACCESS PRACTICE. Each of this edition’s 12 new cases introduces a commonly occurring business issue, giving students hands-on experience using Excel and Access to analyze and solve relevant problems.
  • AUTHENTIC BUSINESS SCENARIOS BLEND EXCEL AND ACCESS PRACTICE. Each of this edition’s 12 new cases introduces a commonly occurring business issue, giving students hands-on experience using Excel and Access to analyze and solve relevant problems.
  • CLEAR SKILL-BUILDING INSTRUCTION DEMONSTRATES HOW TO USE MICROSOFT® ACCESS AND EXCEL 2019 MOST EFFECTIVELY. Hands-on tutorials prepare your students for success in today’s workplace by helping them develop critical spreadsheet and database skills.
  • CLEAR SKILL-BUILDING INSTRUCTION DEMONSTRATES HOW TO USE MICROSOFT® ACCESS AND EXCEL 2019 MOST EFFECTIVELY. Hands-on tutorials prepare your students for success in today’s workplace by helping them develop critical spreadsheet and database skills.
  • EMPHASIS ON DATA ANALYSIS TECHNIQUES REFINES STUDENTS' UNDERSTANDING OF EXCEL. This edition introduces your students to more complex uses of Excel spreadsheets, deepening their understanding of the software and its capabilities in business today.
  • EMPHASIS ON DATA ANALYSIS TECHNIQUES REFINES STUDENTS' UNDERSTANDING OF EXCEL. This edition introduces your students to more complex uses of Excel spreadsheets, deepening their understanding of the software and its capabilities in business today.
  • INTEGRATION CASES WALK STUDENTS THROUGH HOW TO WORK WITH ACCESS AND EXCEL TOGETHER. Two cases require students to apply both Access and Excel simultaneously, helping readers see first-hand how the programs can share data and complement each application's strengths.
  • INTEGRATION CASES WALK STUDENTS THROUGH HOW TO WORK WITH ACCESS AND EXCEL TOGETHER. Two cases require students to apply both Access and Excel simultaneously, helping readers see first-hand how the programs can share data and complement each application's strengths.
  • STUDENTS REFINE PRESENTATION SKILLS THAT ARE IMPORTANT IN BUSINESS TODAY. An additional online tutorial provides insights and guidance designed to help students master the art of effective business presentations.
  • STUDENTS REFINE PRESENTATION SKILLS THAT ARE IMPORTANT IN BUSINESS TODAY. An additional online tutorial provides insights and guidance designed to help students master the art of effective business presentations.
  • Part I: DATABASE CASES USING ACCESS.
  • Tutorial A. Database Design.
  • Tutorial B. Microsoft Access.
  • Case 1. Preliminary Case: Dog Hikes.
  • Case 2. The Parks and Recreation Database.
  • Case 3. The Senior Concierge Database.
  • Case 4. The Fresh Fish Database.
  • Case 5. The Volunteer Fire Company Database
  • Part II: DECISION SUPPORT CASES USING MICROSOFT EXCEL SCENARIO MANAGER.
  • Tutorial C. Building a Decision Support Systems in Excel.
  • Case 6. The Ski Resort Investment Decision.
  • Case 7. The College Town Budget.
  • Part III: DECISION SUPPORT CASES USING MICROSOFT EXCEL SOLVER.
  • Tutorial D. Building a Decision Support System Using Microsoft Excel Solver.
  • Case 8. Rose Tree Regional Airline.
  • Case 9. The Auto Maker Product Mix Problem.
  • Part IV: DECISION SUPPORT CASE USING BASIC ACCESS AND EXCEL FUNCTIONALITY.
  • Case 10. The Donation Letter Analysis.
  • Part V: INTEGRATION CASES USING MICROSOFT ACCESS AND EXCEL.
  • Case 11. San Francisco Fire Incidents.
  • Case 12. San Francisco Fire Incidents: Advanced Analysis.
  • Part VI: ADVANCED SKILLS USING EXCEL.
  • Tutorial E. Guidance for Excel Cases.
  • Product Description
  • 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.
    • TIMELY UPDATES THROUGHOUT THIS EDITION REFLECT THE LATEST CHANGES IN MICROSOFT® OFFICE 2019. The most recent information on Access and Excel, integrated throughout this edition, equips you to present the latest database and spreadsheet tools. Demonstrate how students can maximize the new software advantages as content highlights the most recent changes in MS Office.
    • TIMELY UPDATES THROUGHOUT THIS EDITION REFLECT THE LATEST CHANGES IN MICROSOFT® OFFICE 2019. The most recent information on Access and Excel, integrated throughout this edition, equips you to present the latest database and spreadsheet tools. Demonstrate how students can maximize the new software advantages as content highlights the most recent changes in MS Office.
    • AN UPDATED DATA ANALYTICS TUTORIAL PREPARES STUDENTS TO ANALYZE AND APPLY TODAY'S DATA. Students learn how to collect, organize and examine large amounts of raw data effectively in order to identify significant patterns and draw meaningful conclusions.
    • AN UPDATED DATA ANALYTICS TUTORIAL PREPARES STUDENTS TO ANALYZE AND APPLY TODAY'S DATA. Students learn how to collect, organize and examine large amounts of raw data effectively in order to identify significant patterns and draw meaningful conclusions.
    • COVERAGE HIGHLIGHTS POWERFUL EXCEL ADD-INS AND CAPABILITIES. Students strengthen their data analysis skills as they learn to use Power Queries Excel add-in to extract data from many sources. Students work with data cubes that lets users explore and analyze data from a variety of perspectives and learn to use the PowerPivot add-in for powerful data analytics with data from multiple sources.
    • COVERAGE HIGHLIGHTS POWERFUL EXCEL ADD-INS AND CAPABILITIES. Students strengthen their data analysis skills as they learn to use Power Queries Excel add-in to extract data from many sources. Students work with data cubes that lets users explore and analyze data from a variety of perspectives and learn to use the PowerPivot add-in for powerful data analytics with data from multiple sources.
    • UPDATED SCENARIO MANAGER AND SOLVER TUTORIALS DEMONSTRATE KEY TOOLS WITHIN EXCEL. Timely tutorials introduce these powerful features available in Excel and explain how students can maximize the tools to solve important business challenges.
    • UPDATED SCENARIO MANAGER AND SOLVER TUTORIALS DEMONSTRATE KEY TOOLS WITHIN EXCEL. Timely tutorials introduce these powerful features available in Excel and explain how students can maximize the tools to solve important business challenges.
    • AUTHENTIC BUSINESS SCENARIOS BLEND EXCEL AND ACCESS PRACTICE. Each of this edition’s 12 new cases introduces a commonly occurring business issue, giving students hands-on experience using Excel and Access to analyze and solve relevant problems.
    • AUTHENTIC BUSINESS SCENARIOS BLEND EXCEL AND ACCESS PRACTICE. Each of this edition’s 12 new cases introduces a commonly occurring business issue, giving students hands-on experience using Excel and Access to analyze and solve relevant problems.
    • CLEAR SKILL-BUILDING INSTRUCTION DEMONSTRATES HOW TO USE MICROSOFT® ACCESS AND EXCEL 2019 MOST EFFECTIVELY. Hands-on tutorials prepare your students for success in today’s workplace by helping them develop critical spreadsheet and database skills.
    • CLEAR SKILL-BUILDING INSTRUCTION DEMONSTRATES HOW TO USE MICROSOFT® ACCESS AND EXCEL 2019 MOST EFFECTIVELY. Hands-on tutorials prepare your students for success in today’s workplace by helping them develop critical spreadsheet and database skills.
    • EMPHASIS ON DATA ANALYSIS TECHNIQUES REFINES STUDENTS' UNDERSTANDING OF EXCEL. This edition introduces your students to more complex uses of Excel spreadsheets, deepening their understanding of the software and its capabilities in business today.
    • EMPHASIS ON DATA ANALYSIS TECHNIQUES REFINES STUDENTS' UNDERSTANDING OF EXCEL. This edition introduces your students to more complex uses of Excel spreadsheets, deepening their understanding of the software and its capabilities in business today.
    • INTEGRATION CASES WALK STUDENTS THROUGH HOW TO WORK WITH ACCESS AND EXCEL TOGETHER. Two cases require students to apply both Access and Excel simultaneously, helping readers see first-hand how the programs can share data and complement each application's strengths.
    • INTEGRATION CASES WALK STUDENTS THROUGH HOW TO WORK WITH ACCESS AND EXCEL TOGETHER. Two cases require students to apply both Access and Excel simultaneously, helping readers see first-hand how the programs can share data and complement each application's strengths.
    • STUDENTS REFINE PRESENTATION SKILLS THAT ARE IMPORTANT IN BUSINESS TODAY. An additional online tutorial provides insights and guidance designed to help students master the art of effective business presentations.
    • STUDENTS REFINE PRESENTATION SKILLS THAT ARE IMPORTANT IN BUSINESS TODAY. An additional online tutorial provides insights and guidance designed to help students master the art of effective business presentations.
    • Part I: DATABASE CASES USING ACCESS.
    • Tutorial A. Database Design.
    • Tutorial B. Microsoft Access.
    • Case 1. Preliminary Case: Dog Hikes.
    • Case 2. The Parks and Recreation Database.
    • Case 3. The Senior Concierge Database.
    • Case 4. The Fresh Fish Database.
    • Case 5. The Volunteer Fire Company Database
    • Part II: DECISION SUPPORT CASES USING MICROSOFT EXCEL SCENARIO MANAGER.
    • Tutorial C. Building a Decision Support Systems in Excel.
    • Case 6. The Ski Resort Investment Decision.
    • Case 7. The College Town Budget.
    • Part III: DECISION SUPPORT CASES USING MICROSOFT EXCEL SOLVER.
    • Tutorial D. Building a Decision Support System Using Microsoft Excel Solver.
    • Case 8. Rose Tree Regional Airline.
    • Case 9. The Auto Maker Product Mix Problem.
    • Part IV: DECISION SUPPORT CASE USING BASIC ACCESS AND EXCEL FUNCTIONALITY.
    • Case 10. The Donation Letter Analysis.
    • Part V: INTEGRATION CASES USING MICROSOFT ACCESS AND EXCEL.
    • Case 11. San Francisco Fire Incidents.
    • Case 12. San Francisco Fire Incidents: Advanced Analysis.
    • Part VI: ADVANCED SKILLS USING EXCEL.
    • Tutorial E. Guidance for Excel Cases.
  • Features
  • 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.
    • TIMELY UPDATES THROUGHOUT THIS EDITION REFLECT THE LATEST CHANGES IN MICROSOFT® OFFICE 2019. The most recent information on Access and Excel, integrated throughout this edition, equips you to present the latest database and spreadsheet tools. Demonstrate how students can maximize the new software advantages as content highlights the most recent changes in MS Office.
    • TIMELY UPDATES THROUGHOUT THIS EDITION REFLECT THE LATEST CHANGES IN MICROSOFT® OFFICE 2019. The most recent information on Access and Excel, integrated throughout this edition, equips you to present the latest database and spreadsheet tools. Demonstrate how students can maximize the new software advantages as content highlights the most recent changes in MS Office.
    • AN UPDATED DATA ANALYTICS TUTORIAL PREPARES STUDENTS TO ANALYZE AND APPLY TODAY'S DATA. Students learn how to collect, organize and examine large amounts of raw data effectively in order to identify significant patterns and draw meaningful conclusions.
    • AN UPDATED DATA ANALYTICS TUTORIAL PREPARES STUDENTS TO ANALYZE AND APPLY TODAY'S DATA. Students learn how to collect, organize and examine large amounts of raw data effectively in order to identify significant patterns and draw meaningful conclusions.
    • COVERAGE HIGHLIGHTS POWERFUL EXCEL ADD-INS AND CAPABILITIES. Students strengthen their data analysis skills as they learn to use Power Queries Excel add-in to extract data from many sources. Students work with data cubes that lets users explore and analyze data from a variety of perspectives and learn to use the PowerPivot add-in for powerful data analytics with data from multiple sources.
    • COVERAGE HIGHLIGHTS POWERFUL EXCEL ADD-INS AND CAPABILITIES. Students strengthen their data analysis skills as they learn to use Power Queries Excel add-in to extract data from many sources. Students work with data cubes that lets users explore and analyze data from a variety of perspectives and learn to use the PowerPivot add-in for powerful data analytics with data from multiple sources.
    • UPDATED SCENARIO MANAGER AND SOLVER TUTORIALS DEMONSTRATE KEY TOOLS WITHIN EXCEL. Timely tutorials introduce these powerful features available in Excel and explain how students can maximize the tools to solve important business challenges.
    • UPDATED SCENARIO MANAGER AND SOLVER TUTORIALS DEMONSTRATE KEY TOOLS WITHIN EXCEL. Timely tutorials introduce these powerful features available in Excel and explain how students can maximize the tools to solve important business challenges.
    • AUTHENTIC BUSINESS SCENARIOS BLEND EXCEL AND ACCESS PRACTICE. Each of this edition’s 12 new cases introduces a commonly occurring business issue, giving students hands-on experience using Excel and Access to analyze and solve relevant problems.
    • AUTHENTIC BUSINESS SCENARIOS BLEND EXCEL AND ACCESS PRACTICE. Each of this edition’s 12 new cases introduces a commonly occurring business issue, giving students hands-on experience using Excel and Access to analyze and solve relevant problems.
    • CLEAR SKILL-BUILDING INSTRUCTION DEMONSTRATES HOW TO USE MICROSOFT® ACCESS AND EXCEL 2019 MOST EFFECTIVELY. Hands-on tutorials prepare your students for success in today’s workplace by helping them develop critical spreadsheet and database skills.
    • CLEAR SKILL-BUILDING INSTRUCTION DEMONSTRATES HOW TO USE MICROSOFT® ACCESS AND EXCEL 2019 MOST EFFECTIVELY. Hands-on tutorials prepare your students for success in today’s workplace by helping them develop critical spreadsheet and database skills.
    • EMPHASIS ON DATA ANALYSIS TECHNIQUES REFINES STUDENTS' UNDERSTANDING OF EXCEL. This edition introduces your students to more complex uses of Excel spreadsheets, deepening their understanding of the software and its capabilities in business today.
    • EMPHASIS ON DATA ANALYSIS TECHNIQUES REFINES STUDENTS' UNDERSTANDING OF EXCEL. This edition introduces your students to more complex uses of Excel spreadsheets, deepening their understanding of the software and its capabilities in business today.
    • INTEGRATION CASES WALK STUDENTS THROUGH HOW TO WORK WITH ACCESS AND EXCEL TOGETHER. Two cases require students to apply both Access and Excel simultaneously, helping readers see first-hand how the programs can share data and complement each application's strengths.
    • INTEGRATION CASES WALK STUDENTS THROUGH HOW TO WORK WITH ACCESS AND EXCEL TOGETHER. Two cases require students to apply both Access and Excel simultaneously, helping readers see first-hand how the programs can share data and complement each application's strengths.
    • STUDENTS REFINE PRESENTATION SKILLS THAT ARE IMPORTANT IN BUSINESS TODAY. An additional online tutorial provides insights and guidance designed to help students master the art of effective business presentations.
    • STUDENTS REFINE PRESENTATION SKILLS THAT ARE IMPORTANT IN BUSINESS TODAY. An additional online tutorial provides insights and guidance designed to help students master the art of effective business presentations.
    • Part I: DATABASE CASES USING ACCESS.
    • Tutorial A. Database Design.
    • Tutorial B. Microsoft Access.
    • Case 1. Preliminary Case: Dog Hikes.
    • Case 2. The Parks and Recreation Database.
    • Case 3. The Senior Concierge Database.
    • Case 4. The Fresh Fish Database.
    • Case 5. The Volunteer Fire Company Database
    • Part II: DECISION SUPPORT CASES USING MICROSOFT EXCEL SCENARIO MANAGER.
    • Tutorial C. Building a Decision Support Systems in Excel.
    • Case 6. The Ski Resort Investment Decision.
    • Case 7. The College Town Budget.
    • Part III: DECISION SUPPORT CASES USING MICROSOFT EXCEL SOLVER.
    • Tutorial D. Building a Decision Support System Using Microsoft Excel Solver.
    • Case 8. Rose Tree Regional Airline.
    • Case 9. The Auto Maker Product Mix Problem.
    • Part IV: DECISION SUPPORT CASE USING BASIC ACCESS AND EXCEL FUNCTIONALITY.
    • Case 10. The Donation Letter Analysis.
    • Part V: INTEGRATION CASES USING MICROSOFT ACCESS AND EXCEL.
    • Case 11. San Francisco Fire Incidents.
    • Case 12. San Francisco Fire Incidents: Advanced Analysis.
    • Part VI: ADVANCED SKILLS USING EXCEL.
    • Tutorial E. Guidance for Excel Cases.
  • About the Author
  • 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.
    • TIMELY UPDATES THROUGHOUT THIS EDITION REFLECT THE LATEST CHANGES IN MICROSOFT® OFFICE 2019. The most recent information on Access and Excel, integrated throughout this edition, equips you to present the latest database and spreadsheet tools. Demonstrate how students can maximize the new software advantages as content highlights the most recent changes in MS Office.
    • TIMELY UPDATES THROUGHOUT THIS EDITION REFLECT THE LATEST CHANGES IN MICROSOFT® OFFICE 2019. The most recent information on Access and Excel, integrated throughout this edition, equips you to present the latest database and spreadsheet tools. Demonstrate how students can maximize the new software advantages as content highlights the most recent changes in MS Office.
    • AN UPDATED DATA ANALYTICS TUTORIAL PREPARES STUDENTS TO ANALYZE AND APPLY TODAY'S DATA. Students learn how to collect, organize and examine large amounts of raw data effectively in order to identify significant patterns and draw meaningful conclusions.
    • AN UPDATED DATA ANALYTICS TUTORIAL PREPARES STUDENTS TO ANALYZE AND APPLY TODAY'S DATA. Students learn how to collect, organize and examine large amounts of raw data effectively in order to identify significant patterns and draw meaningful conclusions.
    • COVERAGE HIGHLIGHTS POWERFUL EXCEL ADD-INS AND CAPABILITIES. Students strengthen their data analysis skills as they learn to use Power Queries Excel add-in to extract data from many sources. Students work with data cubes that lets users explore and analyze data from a variety of perspectives and learn to use the PowerPivot add-in for powerful data analytics with data from multiple sources.
    • COVERAGE HIGHLIGHTS POWERFUL EXCEL ADD-INS AND CAPABILITIES. Students strengthen their data analysis skills as they learn to use Power Queries Excel add-in to extract data from many sources. Students work with data cubes that lets users explore and analyze data from a variety of perspectives and learn to use the PowerPivot add-in for powerful data analytics with data from multiple sources.
    • UPDATED SCENARIO MANAGER AND SOLVER TUTORIALS DEMONSTRATE KEY TOOLS WITHIN EXCEL. Timely tutorials introduce these powerful features available in Excel and explain how students can maximize the tools to solve important business challenges.
    • UPDATED SCENARIO MANAGER AND SOLVER TUTORIALS DEMONSTRATE KEY TOOLS WITHIN EXCEL. Timely tutorials introduce these powerful features available in Excel and explain how students can maximize the tools to solve important business challenges.
    • AUTHENTIC BUSINESS SCENARIOS BLEND EXCEL AND ACCESS PRACTICE. Each of this edition’s 12 new cases introduces a commonly occurring business issue, giving students hands-on experience using Excel and Access to analyze and solve relevant problems.
    • AUTHENTIC BUSINESS SCENARIOS BLEND EXCEL AND ACCESS PRACTICE. Each of this edition’s 12 new cases introduces a commonly occurring business issue, giving students hands-on experience using Excel and Access to analyze and solve relevant problems.
    • CLEAR SKILL-BUILDING INSTRUCTION DEMONSTRATES HOW TO USE MICROSOFT® ACCESS AND EXCEL 2019 MOST EFFECTIVELY. Hands-on tutorials prepare your students for success in today’s workplace by helping them develop critical spreadsheet and database skills.
    • CLEAR SKILL-BUILDING INSTRUCTION DEMONSTRATES HOW TO USE MICROSOFT® ACCESS AND EXCEL 2019 MOST EFFECTIVELY. Hands-on tutorials prepare your students for success in today’s workplace by helping them develop critical spreadsheet and database skills.
    • EMPHASIS ON DATA ANALYSIS TECHNIQUES REFINES STUDENTS' UNDERSTANDING OF EXCEL. This edition introduces your students to more complex uses of Excel spreadsheets, deepening their understanding of the software and its capabilities in business today.
    • EMPHASIS ON DATA ANALYSIS TECHNIQUES REFINES STUDENTS' UNDERSTANDING OF EXCEL. This edition introduces your students to more complex uses of Excel spreadsheets, deepening their understanding of the software and its capabilities in business today.
    • INTEGRATION CASES WALK STUDENTS THROUGH HOW TO WORK WITH ACCESS AND EXCEL TOGETHER. Two cases require students to apply both Access and Excel simultaneously, helping readers see first-hand how the programs can share data and complement each application's strengths.
    • INTEGRATION CASES WALK STUDENTS THROUGH HOW TO WORK WITH ACCESS AND EXCEL TOGETHER. Two cases require students to apply both Access and Excel simultaneously, helping readers see first-hand how the programs can share data and complement each application's strengths.
    • STUDENTS REFINE PRESENTATION SKILLS THAT ARE IMPORTANT IN BUSINESS TODAY. An additional online tutorial provides insights and guidance designed to help students master the art of effective business presentations.
    • STUDENTS REFINE PRESENTATION SKILLS THAT ARE IMPORTANT IN BUSINESS TODAY. An additional online tutorial provides insights and guidance designed to help students master the art of effective business presentations.
    • Part I: DATABASE CASES USING ACCESS.
    • Tutorial A. Database Design.
    • Tutorial B. Microsoft Access.
    • Case 1. Preliminary Case: Dog Hikes.
    • Case 2. The Parks and Recreation Database.
    • Case 3. The Senior Concierge Database.
    • Case 4. The Fresh Fish Database.
    • Case 5. The Volunteer Fire Company Database
    • Part II: DECISION SUPPORT CASES USING MICROSOFT EXCEL SCENARIO MANAGER.
    • Tutorial C. Building a Decision Support Systems in Excel.
    • Case 6. The Ski Resort Investment Decision.
    • Case 7. The College Town Budget.
    • Part III: DECISION SUPPORT CASES USING MICROSOFT EXCEL SOLVER.
    • Tutorial D. Building a Decision Support System Using Microsoft Excel Solver.
    • Case 8. Rose Tree Regional Airline.
    • Case 9. The Auto Maker Product Mix Problem.
    • Part IV: DECISION SUPPORT CASE USING BASIC ACCESS AND EXCEL FUNCTIONALITY.
    • Case 10. The Donation Letter Analysis.
    • Part V: INTEGRATION CASES USING MICROSOFT ACCESS AND EXCEL.
    • Case 11. San Francisco Fire Incidents.
    • Case 12. San Francisco Fire Incidents: Advanced Analysis.
    • Part VI: ADVANCED SKILLS USING EXCEL.
    • Tutorial E. Guidance for Excel Cases.
  • Table of Contents
  • 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.
    • TIMELY UPDATES THROUGHOUT THIS EDITION REFLECT THE LATEST CHANGES IN MICROSOFT® OFFICE 2019. The most recent information on Access and Excel, integrated throughout this edition, equips you to present the latest database and spreadsheet tools. Demonstrate how students can maximize the new software advantages as content highlights the most recent changes in MS Office.
    • TIMELY UPDATES THROUGHOUT THIS EDITION REFLECT THE LATEST CHANGES IN MICROSOFT® OFFICE 2019. The most recent information on Access and Excel, integrated throughout this edition, equips you to present the latest database and spreadsheet tools. Demonstrate how students can maximize the new software advantages as content highlights the most recent changes in MS Office.
    • AN UPDATED DATA ANALYTICS TUTORIAL PREPARES STUDENTS TO ANALYZE AND APPLY TODAY'S DATA. Students learn how to collect, organize and examine large amounts of raw data effectively in order to identify significant patterns and draw meaningful conclusions.
    • AN UPDATED DATA ANALYTICS TUTORIAL PREPARES STUDENTS TO ANALYZE AND APPLY TODAY'S DATA. Students learn how to collect, organize and examine large amounts of raw data effectively in order to identify significant patterns and draw meaningful conclusions.
    • COVERAGE HIGHLIGHTS POWERFUL EXCEL ADD-INS AND CAPABILITIES. Students strengthen their data analysis skills as they learn to use Power Queries Excel add-in to extract data from many sources. Students work with data cubes that lets users explore and analyze data from a variety of perspectives and learn to use the PowerPivot add-in for powerful data analytics with data from multiple sources.
    • COVERAGE HIGHLIGHTS POWERFUL EXCEL ADD-INS AND CAPABILITIES. Students strengthen their data analysis skills as they learn to use Power Queries Excel add-in to extract data from many sources. Students work with data cubes that lets users explore and analyze data from a variety of perspectives and learn to use the PowerPivot add-in for powerful data analytics with data from multiple sources.
    • UPDATED SCENARIO MANAGER AND SOLVER TUTORIALS DEMONSTRATE KEY TOOLS WITHIN EXCEL. Timely tutorials introduce these powerful features available in Excel and explain how students can maximize the tools to solve important business challenges.
    • UPDATED SCENARIO MANAGER AND SOLVER TUTORIALS DEMONSTRATE KEY TOOLS WITHIN EXCEL. Timely tutorials introduce these powerful features available in Excel and explain how students can maximize the tools to solve important business challenges.
    • AUTHENTIC BUSINESS SCENARIOS BLEND EXCEL AND ACCESS PRACTICE. Each of this edition’s 12 new cases introduces a commonly occurring business issue, giving students hands-on experience using Excel and Access to analyze and solve relevant problems.
    • AUTHENTIC BUSINESS SCENARIOS BLEND EXCEL AND ACCESS PRACTICE. Each of this edition’s 12 new cases introduces a commonly occurring business issue, giving students hands-on experience using Excel and Access to analyze and solve relevant problems.
    • CLEAR SKILL-BUILDING INSTRUCTION DEMONSTRATES HOW TO USE MICROSOFT® ACCESS AND EXCEL 2019 MOST EFFECTIVELY. Hands-on tutorials prepare your students for success in today’s workplace by helping them develop critical spreadsheet and database skills.
    • CLEAR SKILL-BUILDING INSTRUCTION DEMONSTRATES HOW TO USE MICROSOFT® ACCESS AND EXCEL 2019 MOST EFFECTIVELY. Hands-on tutorials prepare your students for success in today’s workplace by helping them develop critical spreadsheet and database skills.
    • EMPHASIS ON DATA ANALYSIS TECHNIQUES REFINES STUDENTS' UNDERSTANDING OF EXCEL. This edition introduces your students to more complex uses of Excel spreadsheets, deepening their understanding of the software and its capabilities in business today.
    • EMPHASIS ON DATA ANALYSIS TECHNIQUES REFINES STUDENTS' UNDERSTANDING OF EXCEL. This edition introduces your students to more complex uses of Excel spreadsheets, deepening their understanding of the software and its capabilities in business today.
    • INTEGRATION CASES WALK STUDENTS THROUGH HOW TO WORK WITH ACCESS AND EXCEL TOGETHER. Two cases require students to apply both Access and Excel simultaneously, helping readers see first-hand how the programs can share data and complement each application's strengths.
    • INTEGRATION CASES WALK STUDENTS THROUGH HOW TO WORK WITH ACCESS AND EXCEL TOGETHER. Two cases require students to apply both Access and Excel simultaneously, helping readers see first-hand how the programs can share data and complement each application's strengths.
    • STUDENTS REFINE PRESENTATION SKILLS THAT ARE IMPORTANT IN BUSINESS TODAY. An additional online tutorial provides insights and guidance designed to help students master the art of effective business presentations.
    • STUDENTS REFINE PRESENTATION SKILLS THAT ARE IMPORTANT IN BUSINESS TODAY. An additional online tutorial provides insights and guidance designed to help students master the art of effective business presentations.
    • Part I: DATABASE CASES USING ACCESS.
    • Tutorial A. Database Design.
    • Tutorial B. Microsoft Access.
    • Case 1. Preliminary Case: Dog Hikes.
    • Case 2. The Parks and Recreation Database.
    • Case 3. The Senior Concierge Database.
    • Case 4. The Fresh Fish Database.
    • Case 5. The Volunteer Fire Company Database
    • Part II: DECISION SUPPORT CASES USING MICROSOFT EXCEL SCENARIO MANAGER.
    • Tutorial C. Building a Decision Support Systems in Excel.
    • Case 6. The Ski Resort Investment Decision.
    • Case 7. The College Town Budget.
    • Part III: DECISION SUPPORT CASES USING MICROSOFT EXCEL SOLVER.
    • Tutorial D. Building a Decision Support System Using Microsoft Excel Solver.
    • Case 8. Rose Tree Regional Airline.
    • Case 9. The Auto Maker Product Mix Problem.
    • Part IV: DECISION SUPPORT CASE USING BASIC ACCESS AND EXCEL FUNCTIONALITY.
    • Case 10. The Donation Letter Analysis.
    • Part V: INTEGRATION CASES USING MICROSOFT ACCESS AND EXCEL.
    • Case 11. San Francisco Fire Incidents.
    • Case 12. San Francisco Fire Incidents: Advanced Analysis.
    • Part VI: ADVANCED SKILLS USING EXCEL.
    • Tutorial E. Guidance for Excel Cases.
 
Cart subtotal (0 items): $0.00