Sale!

(eBook PDF) Exploring VBA for Microsoft Office 2016 Brief

Original price was: $50.00.Current price is: $35.00.

(eBook PDF) Exploring VBA for Microsoft Office 2016 Brief – Instant Download

SKU: EB-76897 Categories: , Tags: , , ,

(eBook PDF) Exploring VBA for Microsoft Office 2016 Brief – Digital Ebook – Instant Delivery Download

product details:

  • ISBN-10 ‏ : ‎ 0134497082
  • ISBN-13 ‏ : ‎ 978-0134497082
  • Author: Mary Anne Poatsy, Robert Grauer, Jason Davidson 

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.

table of contents:

  1. Getting Started with VBA
    Objectives
    Case Study: Acme Consulting
  2. Introduction to VBA
    Using VBA and Getting Help
    Identifying Code in the Code Window
    Creating, Running, and Debugging Procedures
    Creating a Message Box
  3. Variables, Constants, Inputs, and Outputs
    Declaring and Using Variables and Constants
    Referencing Values and Arrays
    Creating an Input Box
    Performing Calculations
  4. Decision Structures
    Using Decision Structures
    Performing Data Validation
    Using Logical Operators
  5. Repetition Structures
    Using the For…Next Structure
    Using the Do…Loop Structure
  6. Excel and VBA
    Objectives
    Case Study: Expert Financial Services
  7. Forms and Controls
    Creating Forms
    Adding Controls to Forms
    Adjusting Specialized Properties
    Inserting Controls on a Worksheet
  8. Procedures and Functions for Form Controls
    Adding a Procedure to a Control
    Creating and Calling a Function Procedure
  9. Loan Payment Schedule and Disclosure Worksheets
    Creating a List in a Worksheet
    Preparing an Application for Distribution
  10. 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
  11. Working with Recordsets
    Using DAQ to Access Data
  12. Forms, Reports, and Errors in VBA
    Using VBA to Add Events to Forms
  13. Chapter Objectives Review
    Key Terms Matching
    Multiple Choice
    Practice Exercises
    Mid-Level Exercises
    Beyond the Classroom
    Capstone Exercise

people also search: