Exploring VBA for Microsoft Office 2013, Brief
Published on 19. August 2014
Book
Paperback/Softback
224 pages
978-0-13-342816-2 (ISBN)
Description
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.
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.
More details
Series
Language
English
Place of publication
United States
Publishing group
Pearson Education (US)
Target group
College/higher education
Dimensions
Height: 272 mm
Width: 213 mm
Thickness: 15 mm
Weight
449 gr
ISBN-13
978-0-13-342816-2 (9780133428162)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Other editions
Previous edition
Robert Grauer | Mary Anne S. Poatsy | Rebecca Lawson
Exploring Microsoft Office 2010 Getting Started with Web Apps
Book
10/2011
Prentice Hall
€29.44
Article exhausted; check for reprint
Content
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
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