Exploring VBA for Microsoft Office 2016 Brief

Mary Anne Poatsy all

15% Off

Exploring VBA for Microsoft Office 2016 Brief

By Mary Anne Poatsy, Robert T. Grauer, Jason Davidson
Temporarily out of stock
This may take 4-6 weeks to reach you. For more information, contact us.
Don't wait. Order the eBook version instead.
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.




Mary Anne Poatsy, Series Editor

Mary Anne is a senior faculty member at Montgomery County Community College, teaching various computer application and concepts courses in face-to-face and online environments. She holds a B.A. in Psychology and Education from Mount Holyoke College and an M.B.A. in Finance from Northwestern University’s Kellogg Graduate School of Management. Mary Anne has more than 12 years of educational experience. She is currently adjunct faculty at Gwynedd-Mercy College and Montgomery County Community College. She has also taught at Bucks County Community College and Muhlenberg College, as well as conducted personal training. Before teaching, she was Vice President at Shearson Lehman in the Municipal Bond Investment Banking Department.


Jason Davidson

Jason Davidson is a faculty member in the College of Business at Butler University, where he teaches Advanced Web Design, Data Networks, Data Analysis and Business Modeling, and introductory information systems courses. He is the co-author of Exploring Microsoft Excel 2013 Comprehensive, Exploring Microsoft Office 2013 Volume 2, Exploring Microsoft Office 2013 Plus, and Exploring VBA for Microsoft Office 2013. With a background in media development, prior to joining the faculty at Butler, he worked in the technical publishing industry. Along with teaching, he currently serves as an IT consultant for regional businesses in the Indianapolis area. He holds a B.A. in Telecommunication Arts from Butler University and an M.B.A. from Morehead State University. He lives in Indianapolis, Indiana, and in his free time enjoys road biking, photography, and spending time with his family.


Dr. Robert T. Grauer, Creator of the Exploring Series

Bob Grauer is Professor Emeritus in the Department of Computer Information Systems at the University of Miami, where he is a multiple winner of the Outstanding Teaching Award in the School of Business, most recently in 2009. He has written numerous COBOL texts and is the vision behind the Exploring Office series, with more than three million books in print. His work has been translated into three foreign languages and is used in all aspects of higher education at both national and international levels. Bob Grauer has consulted for several major corporations including IBM and American Express. He received his Ph.D. in Operations Research in 1972 from the Polytechnic Institute of Brooklyn.




  • 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