Exploring Vba For Microsoft Office 2016 Brief

Paperback | November 22, 2016

byMary Anne Poatsy, Robert Grauer

not yet rated|write a review

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 ® 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.

Pricing and Purchase Info

$54.28

In stock online
Ships free on orders over $25
HURRY, ONLY 2 LEFT!

From the Publisher

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-clic...

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

other books by Mary Anne Poatsy

Exploring Microsoft Word 2016 Comprehensive
Exploring Microsoft Word 2016 Comprehensive

Paperback|Mar 22 2016

$134.94 online$135.00list price
see all books by Mary Anne Poatsy
Format:PaperbackDimensions:228 pages, 10.8 × 8.6 × 0.6 inPublished:November 22, 2016Publisher:Pearson EducationLanguage:English

The following ISBNs are associated with this title:

ISBN - 10:0134497082

ISBN - 13:9780134497082

Customer Reviews of Exploring Vba For Microsoft Office 2016 Brief

Reviews

Extra Content

Table of Contents

Getting Started with VBA

                Objectives

Case Study: Acme Consulting

Introduction to VBA

Using VBA and Getting Help

Identifying Code in the Code Window

Creating, Running, and Debugging Procedures

Creating a Message Box

Variables, Constants, Inputs, and Outputs

Declaring and Using Variables and Constants

Referencing Values and Arrays

Creating an Input Box

Performing Calculations

Decision Structures

Using Decision Structures

Performing Data Validation

Using Logical Operators

Repetition Structures

                                Using the For…Next Structure

                                Using the Do…Loop Structure

Excel and VBA

                Objectives

Case Study: Expert Financial Services

Forms and Controls

Creating Forms

Adding Controls to Forms

Adjusting Specialized Properties

Inserting Controls on a Worksheet

Procedures and Functions for Form Controls

Adding a Procedure to a Control

Creating and Calling a Function Procedure

Loan Payment Schedule and Disclosure Worksheets

Creating a List in a Worksheet

Preparing an Application for Distribution

 

Access and VBA

         Objectives

Case Study: Garten Sporting Goods

VBA in Access

Writing Code in Modules

                Writing Code in Forms and Reports

                Working with Objects

                Creating Functions

Working with Recordsets

                Using DAQ to Access Data   

Forms, Reports, and Errors in VBA

                Using VBA to Add Events to Forms


            Chapter Objectives Review

                Key Terms Matching

                Multiple Choice

                Practice Exercises

                Mid-Level Exercises

                Beyond the Classroom

                Capstone Exercise