Exploring VBA for Microsoft Office 2016 Brief

Exploring VBA for Microsoft Office 2016 Brief

By (author)  , By (author)  , By (author) 

Free delivery worldwide

Available. Dispatched from the UK in 2 business days
When will my order arrive?

Not expected to be delivered to the United States by Christmas Not expected to be delivered to the United States by Christmas


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. Also available with MyITLab MyITLab (R) is an online homework, tutorial, and assessment program designed for Information Technology (IT) courses, which engages students and improves results. HTML5 Simulation exercises and Live-in-Application Grader projects come with the convenience of auto-grading and instant feedback, helping students learn more quickly and effectively. Digital badges lets students showcase their Microsoft Office or Computer Concepts competencies, keeping them motivated and focused on their future careers. MyITLab builds the critical skills needed for college and career success. Note: You are purchasing a standalone product; MyITLab does not come packaged with this content. Students, if interested in purchasing this title with MyITLab, ask your instructor for the correct package ISBN and Course ID. Instructors, contact your Pearson representative for more information.show more

Product details

  • Paperback | 228 pages
  • 216 x 276 x 12.7mm | 408.23g
  • Pearson Education (US)
  • Pearson
  • United States
  • English
  • 0134497082
  • 9780134497082

About Mary Anne Poatsy

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.show more

Table of contents

Getting Started with VBAObjectivesCase Study: Acme ConsultingIntroduction to VBA Using VBA and Getting HelpIdentifying Code in the Code WindowCreating, Running, and Debugging ProceduresCreating a Message Box Variables, Constants, Inputs, and OutputsDeclaring and Using Variables and ConstantsReferencing Values and ArraysCreating an Input BoxPerforming CalculationsDecision Structures Using Decision StructuresPerforming Data ValidationUsing Logical OperatorsRepetition Structures Using the For...Next Structure Using the Do...Loop StructureExcel and VBAObjectivesCase Study: Expert Financial ServicesForms and Controls Creating FormsAdding Controls to FormsAdjusting Specialized PropertiesInserting Controls on a Worksheet Procedures and Functions for Form ControlsAdding a Procedure to a ControlCreating and Calling a Function ProcedureLoan Payment Schedule and Disclosure WorksheetsCreating a List in a WorksheetPreparing an Application for Distribution Access and VBA ObjectivesCase Study: Garten Sporting GoodsVBA in AccessWriting Code in ModulesWriting Code in Forms and ReportsWorking with ObjectsCreating FunctionsWorking with Recordsets Using DAQ to Access Data Forms, Reports, and Errors in VBA Using VBA to Add Events to Forms Chapter Objectives ReviewKey Terms MatchingMultiple ChoicePractice ExercisesMid-Level ExercisesBeyond the Classroom Capstone Exerciseshow more