Exploring Getting Started with VBA for Office 2013 (Subscription)

This is the eBook of the printed book and may not include any media, website access codes, or print supplements that may come packaged with the bound book. 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. Move students beyond the 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, any time.   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. NOTE: Before purchasing, check with your instructor to ensure you select the correct ISBN. Several versions of Pearson's MyLab & Mastering products exist for each title, and registrations are not transferable. To register for and use Pearson's MyLab & Mastering products, you may also need a Course ID, which your instructor will provide.   Used books, rentals, and purchases made outside of Pearson If purchasing or renting from companies other than Pearson, the access codes for Pearson's MyLab & Mastering products may not be included, may be incorrect, or may be previously redeemed. Check with the seller before completing your purchase.  

Table of Contents:
Chapter 1: Getting Started with VBA Case Study: ACME Consulting 1 Introduction to VBA               2 Using VBA and Getting Help 2 Identifying Code in the Code Window 5 Creating, Running, and Debugging Procedures 8 Creating a Message Box 9 Variables, Constants, Inputs, and Outputs         20 Declaring and Using Variables and Constants 20 Creating an Input Box 25 Performing Calculations 27 Decision Structures               37 Using Decision Structures 37 Performing Data Validation 42 Using Logical Operators 43 Repetition Structures            51 Using the For…Next Structure 51 Using the Do…Loop Structure 52 Chapter Objectives Review 58 Key Terms Matching 59 Multiple Choice 60 Practice Exercises 61 Mid-Level Exercises              66 Beyond the Classroom 69 Capstone Exercise 70   Chapter 2: Excel and VBA 73 Case Study: Expert Financial Services               73 Forms and Controls             74 Creating Forms 74 Adding Controls to Forms 76 Adjusting Specialized Properties 81 Inserting Controls on a Worksheet 84 Procedures and Functions for Form Controls   94 Adding a Procedure to a Control 94 Creating and Calling a Function Procedure 97 Loan Payment Schedule and Disclosure Worksheets      106 Creating a List in a Worksheet 106 Preparing an Application for Distribution 108 Chapter Objectives Review 116 Key Terms Matching 117 Multiple Choice 118 Practice Exercises 119 Mid-Level Exercises              127 Beyond the Classroom 132 Capstone Exercise 133   Chapter 3: Customizing Access with VBA 137 Case Study: Croton Sporting Goods  137 VBA in Access       138 Writing Code in Modules 138 Writing Code for Forms and Reports 140 Working with Objects 142 Creating Functions 145 Working with Recordsets    154 Using DAO to Access Data 154 Using ADO to Access Data 158 Forms, Reports, and Errors in VBA     167 Using VBA to Add Events to Forms 167 Adding VBA to Reports 170 Handling Errors in VBA 172 Chapter Objectives Review 180 Key Terms Matching 181 Multiple Choice 182 Practice Exercises 183 Mid-Level Exercises              187 Beyond the Classroom 192 Capstone Exercise 193 Glossary 197 Index 201