Exploring VBA for Microsoft Office 2016 Brief eBook

Mary Anne Poatsy all

Exploring VBA for Microsoft Office 2016 Brief eBook

By Mary Anne Poatsy, Robert T. Grauer, Jason Davidson
In stock
Add to cart
Mary Anne Poatsy all
Published Date

This three-chapter book provides an overview of VBA and then a full chapter each on VBA in Excel and VBA in Access. It is an ideal complement to the Excel or Access Comprehensive textbook for those looking for more VBA coverage.


Beyond point-and-click

The goal of the Exploring series is to move students beyond the point-and-click, to understanding the why and how behind each skill. And because so much learning takes place outside of the classroom, this series provides learning tools that students can access anywhere, anytime. Students go to college now with a different set of skills than they did years ago. With this in mind, the Exploring series seeks to move students beyond the basics of the software at a faster pace, without sacrificing coverage of the fundamental skills that everyone needs to know.



The full text downloaded to your computer

With eBooks you can:

  • search for key concepts, words and phrases
  • make highlights and notes as you study
  • share your notes with friends

eBooks are downloaded to your computer and accessible either offline through the Bookshelf (available as a free download), available online and also via the iPad and Android apps.

Upon purchase, you'll gain instant access to this eBook.

Time limit

The eBooks products do not have an expiry date. You will continue to access your digital ebook products whilst you have your Bookshelf installed.



  • The How/Why approach helps students go from learning steps and performing tasks to gaining a true understanding of how to apply Microsoft Office skills.
    • White/Yellow Pages clearly distinguish the theory (white pages) from the skills covered in the Hands-On Exercises (yellow pages) so students always know what they are supposed to be doing.
    • Case Study presents a scenario for the chapter, creating a story that ties the Hands-On Exercises together.
    • Hands-On Exercise Videos–tied to each Hands-On Exercise–walk students through the steps of the exercise while weaving in conceptual information related to the Case Study and objectives.
  • The Outcomes focus keep both students and instructors aware of the higher-level learning goals and how those are achieved through discreet objectives and skills.
    • Outcomes are presented at the beginning of each chapter, identifying the learning goals that will be achieved in the material ahead.
    • Enhanced Objective Mapping give students a learning path for the chapter, from the objectives list in the beginning through the exercises at the end.
      • Objectives List: a simple list of key objectives covered in the chapter, with page numbers so students can skip to the objectives where they need the most help.
      • Step Icons appear in the white pages and reference the step numbers in the Hands-On Exercises, providing a correlation between the two so students can easily find conceptual help when they are working hands-on and need a refresher.
      • Quick Concepts Checks appear at the end of each white page section. These questions cover the essential concepts students will need to be successful in working the Hands-On Exercises. Page numbers are included for easy reference to help students locate the answers.
      • Chapter Objectives Review, near the end of the chapter, reviews all the important concepts throughout the chapter.
        • NEW! Chapter Objectives Review is redesigned in an easy-to-read bulleted format.
  • Microsoft Office Specialist (MOS) Certification Guide directs anyone interested in prepping for the MOS exam to the specific locations to find all content required for the test.
  • End-of-Chapter Exercises offer instructors several options for assessment, with 12—15 exercises ranging from multiple choice questions to open-ended projects: Multiple Choice, Key Terms Matching, Practice Exercises, Mid-Level Exercises, Beyond the Classroom Exercises, and Capstone Exercises.
    • NEW! Every chapter now includes a Key Terms Matching exercise, a Collaboration Case, and Soft Skills Case.
    • NEW! Key Terms Matching exercises require students to match key terms to their definitions. This requires students to work actively with important vocabulary and prove conceptual understanding.
    • Enhanced! Mid-Level Exercises
      • Creative Case (for PowerPoint and Word) allows students some flexibility and creativity, without being bound by a definitive solution.
      • Analysis Case (for Excel and Access) requires students to interpret the data they are using to answer an analytic question.
      • Discover Steps encourage students to use Help or to problem-solve to accomplish a task.
    • Application Capstone exercises allow instructors to test students on the entire contents of a single application.
Table of contents
  • Getting Started with VBA
  • Introduction to VBA
  • Variables, Constants, Inputs, and Outputs
  • Decision Structures
  • Repetition Structures
  • Excel and VBA
  • Forms and Controls
  • Procedures and Functions for Form Controls
  • Loan Payment Schedule and Disclosure Worksheets
  • Access and VBA
  • VBA in Access
  • Working with Recordsets
  • Forms, Reports, and Errors in VBA