Cart
Free US shipping over $10
Proud to be B-Corp

Exploring VBA for Microsoft Office 2013, Brief Mary Anne Poatsy

Exploring VBA for Microsoft Office 2013, Brief By Mary Anne Poatsy

Exploring VBA for Microsoft Office 2013, Brief by Mary Anne Poatsy


$5.71
Condition - Good
Only 1 left

Faster Shipping

Get this product faster from our US warehouse

Exploring VBA for Microsoft Office 2013, Brief Summary

Exploring VBA for Microsoft Office 2013, Brief by Mary Anne Poatsy

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

Additional information

CIN0133428168G
9780133428162
0133428168
Exploring VBA for Microsoft Office 2013, Brief by Mary Anne Poatsy
Used - Good
Paperback
Pearson Education (US)
20140819
224
N/A
Book picture is for illustrative purposes only, actual binding, cover or edition may vary.
This is a used book - there is no escaping the fact it has been read by someone else and it will show signs of wear and previous use. Overall we expect it to be in good condition, but if you are not entirely satisfied please get in touch with us

Customer Reviews - Exploring VBA for Microsoft Office 2013, Brief