Microsoft Access programming : pocket primer / Julitta Korol.

Format:

Book

Author/Creator:

Korol, Julitta, author.

Series:

Pocket primer.

Pocket Primer

Language:

English

Subjects (All):

Microsoft Access.

Visual Basic for Applications (Computer program language).

Physical Description:

1 online resource (243 pages) : illustrations.

Edition:

1st ed.

Place of Publication:

Dulles, Virginia ; Boston, Massachusetts ; New Delhi : Mercury Learning and Information, [2015]

Language Note:

English

Summary:

As part of the Pocket Primer series, this book provides an overview of the major concepts to program Microsoft Access/VBA. The focus of this book is on basic programming instructions for both Access 2013 and previous versions. FEATURES: * Provides an overview of the most important Access/VBA programming techniques * Covers both Access 2013 and 2010 versions * Includes CD with source code, projects, and figures

Contents:

Cover

Title

Copyright

Contents

Dedication

Acknowledgments

Introduction

1. Getting Started with Access VBA

Introduction to VBA Programming in Access

Understanding VBA Modules and Procedure Types

Writing Procedures in a Standard Module

Hands-On 1.1. Working in a Standard Module

Executing Your Procedures

Hands-On 1.2. Running Procedures and Functions

Understanding Class Modules

Events, Event Properties, and Event Procedures

Why Use Events?

Walking Through an Event Procedure

Hands-On 1.3. Writing an Event Procedure

Compiling Your Procedures

Placing a Database in a Trusted Location

Hands-On 1.4. Placing an Access Database in a Trusted Location

Summary

2. Getting to Know Visual Basic Editor (VBE)

Understanding the Project Explorer Window

Understanding the Properties Window

Hands-On 2.1. Using the Properties Window to View Control Properties

Understanding the Code Window

Other Windows in the VBE

Assigning a Name to the VBA Project

Renaming the Module

Syntax and Programming Assistance

List Properties/Methods

Parameter Info

List Constants

Quick Info

Complete Word

Indent/Outdent

Hands-On 2.2. Using the Indent/Outdent Feature

Comment Block/Uncomment Block

Using the Object Browser

Hands-On 2.3. Using the Object Browser

Using the VBA Object Library

Hands-On 2.4. Using Built-In VBA Functions

Using the Immediate Window

Hands-On 2.5. Experiments in the Immediate Window

Hands-On 2.6. Asking Questions in the Immediate Window

3. Access VBA Fundamentals

Introduction to Data Types

Understanding and Using Variables

Declaring Variables

Hands-On 3.1. Using Variables

Specifying the Data Type of a Variable

Hands-On 3.2. Understanding the Data Type of a Variable

Using Type Declaration Characters.

Hands-On 3.3. Using Type Declaration Characters in Variable Names

Assigning Values to Variables

Hands-On 3.4. Assigning Values to Variables

Forcing Declaration of Variables

Hands-On 3.5. Forcing Declaration of Variables

Understanding the Scope of Variables

Procedure-Level (Local) Variables

Module-Level Variables

Hands-On 3.6. Understanding Module-Level Variables

Project-Level Variables

Understanding the Lifetime of Variables

Using Temporary Variables

Creating a Temporary Variable with a TempVars Collection Object

Retrieving Names and Values of TempVar Objects

Using Temporary Global Variables in Expressions

Removing a Temporary Variable from a TempVars Collection Object

Using Static Variables

Hands-On 3.7. Using Static Variables

Using Object Variables

Hands-On 3.8. Working with Object Variables

Disposing of Object Variables

Finding a Variable Definition

Hands-On 3.9. Finding a Variable Definition

Determining the Data Type of a Variable

Hands-On 3.10. Asking Questions about the Variable Type

Using Constants in VBA Procedures

Intrinsic Constants

Hands-On 3.11. Exploring Access's Constants

Hands-On 3.12. Using Intrinsic Constants in a VBA Procedure

4. Access VBA Built-In and Custom Functions

Writing Function Procedures

Hands-On 4.1. Writing a Function Procedure with Arguments

Various Methods of Running Function Procedures

Hands-On 4.2. Executing a Function Procedure from the Immediate Window

Hands-On 4.3. Executing a Function Procedure from a Subroutine

Specifying the Data Type for a Function's Result

Hands-On 4.4. Calling a Function from a Procedure

Passing Arguments By Reference and By Value

Hands-On 4.5. Passing Arguments to Subroutines and Functions

Using Optional Arguments

Hands-On 4.6. Using Optional Arguments.

Using the IsMissing Function

Using VBA Built-In Functions for User Interaction

Using the MsgBox Function

Hands-On 4.7. Formatting the Message Box

Hands-On 4.8. Using the MsgBox Function with Arguments

Returning Values from the MsgBox Function

Hands-On 4.9. Returning Values from the MsgBox Function

Using the InputBox Function

Hands-On 4.10. Using the InputBox Function

Converting Data Types

Hands-On 4.11. Converting Data Types

5. Adding Decisions to Your Access VBA Programs

Relational and Logical Operators

If...Then Statement

Hands-On 5.1. Using the If…Then Statement

Multiline If…Then Statement

Hands-On 5.2. Using the Multiline If…Then Statement

Decisions Based on More Than One Condition

Hands-On 5.3. Using the If…Then…AND Statement

If…Then…Else Statement

Hands-On 5.4. Using the If…Then…Else Statement

If...Then...ElseIf Statement

Nested If…Then Statements

Hands-On 5.5. Using Nested If…Then Statements

Select Case Statement

Hands-On 5.6. Using the Select Case Statement

Using Is with the Case Clause

Specifying a Range of Values in a Case Clause

Hands-On 5.7. Using the Select Case Statement in a Function

Specifying Multiple Expressions in a Case Clause

6. Adding Repeating Actions to Your Access VBA Programs

Using the Do…While Statement

Hands-On 6.1. Using the Do…While Statement

Another Approach to the Do…While Statement

Hands-On 6.2. Using the Do…While Statement with a Condition at the Bottom of the Loop

Using the Do…Until Statement

Hands-On 6.3. Using the Do…Until Statement

Another Approach to the Do…Until Statement

Hands-On 6.4. Using the Do…Until Statement with a Condition at the Bottom of the Loop

Using the For…Next Statement

Hands-On 6.5. Using the For…Next Statement

Using the For Each…Next Statement.

Hands-On 6.6. Using the For Each…Next Statement

Exiting Loops Early

Hands-On 6.7. Early Exit from a Loop

Nested Loops

Hands-On 6.8. Using Nested Loops

7. Keeping Track of Multiple Values Using Arrays

Understanding Arrays

Declaring Arrays

Array Upper and Lower Bounds

Initializing and Filling an Array

Filling an Array Using Individual Assignment Statements

Filling an Array Using the Array Function

Filling an Array Using For…Next Loop

Using a One-Dimensional Array

Hands-On 7.1. Using a One-Dimensional Array

Arrays and Looping Statements

Hands-On 7.2. Using the For Each…Next Statement to List the Array Elements

Hands-On 7.3. Passing Elements of an Array to Another Procedure

Hands-On 7.4. Using Arrays and Loops in Real Life

Using a Two-Dimensional Array

Hands-On 7.5. Using a Two-Dimensional Array

Static and Dynamic Arrays

Hands-On 7.6. Using a Dynamic Array

Array Functions

The Array Function

Hands-On 7.7. Using the Array Function

The IsArray Function

Hands-On 7.8. Using the IsArray Function

The Erase Function

Hands-On 7.9. Removing Data from an Array

The LBound and UBound Functions

Hands-On 7.10. Finding the Lower and Upper Bounds of an Array

Errors in Arrays

Hands-On 7.11. Understanding Errors in Arrays

Parameter Arrays

Hands-On 7.12. Working with Parameter Arrays

Passing Arrays to Function Procedures

Hands-On 7.13. Passing an Array to a Function Procedure

Sorting an Array

Hands-On 7.14. Sorting an Array

8. Keeping Track of Multiple Values Using Object Collections

Working with Collections of Objects

Declaring a Custom Collection

Adding Objects to a Custom Collection

Hands-On 8.1. Creating a Custom Collection

Removing Objects from a Custom Collection

Hands-On 8.2. Removing Objects from a Collection.

Creating Custom Objects in Class Modules

Creating a Class

Custom Project 8.1. (Step 1) Creating a Class Module

Variable Declarations

Custom Project 8.1. (Step 2) Declaring Class Members

Defining the Properties for the Class

Creating the Property Get Procedures

Custom Project 8.1. (Step 3) Writing Property Get Procedures

Creating the Property Let Procedures

Custom Project 8.1. (Step 4) Writing Property Let Procedures

Creating the Class Methods

Custom Project 8.1. (Step 5) Writing Class Methods

Creating an Instance of a Class

Custom Project 8.1. (Step 6) Creating an Instance of a Class

Event Procedures in the Class Module

Creating the User Interface

Custom Project 8.1. (Step 7) Designing a User Form

Custom Project 8.1. (Step 8) Writing Event Procedures

Running the Custom Application

Custom Project 8.1. (Step 9) Running the Custom Project

Watching the Execution of Your VBA Procedures

Custom Project 8.1. (Step 10) Custom Project Code Walkthrough

9. Getting to Know Built-In Tools for Testing and Debugging

Stopping a Procedure

Using Breakpoints

Custom Project 9.1. Debugging a Function Procedure

Removing Breakpoints

Using the Immediate Window in Break Mode

Using the Stop Statement

Using the Assert Statement

Using the Add Watch Window

Hands-On 9.1. Watching the Values of VBA Expressions

Removing Watch Expressions

Using Quick Watch

Hands-On 9.2. Using the Quick Watch Dialog Box

Using the Locals Window

Hands-On 9.3. Using the Locals Window

Using the Call Stack Dialog Box

Stepping Through VBA Procedures

Hands-On 9.4. Stepping Through a Procedure

Stepping Over a Procedure

Hands-On 9.5. Stepping Over a Procedure

Stepping Out of a Procedure

Running a Procedure to Cursor

Setting the Next Statement.

Showing the Next Statement.

Notes:

Includes index.

Description based on online resource; title from PDF title page (ebrary, viewed July 31, 2017).

Description based on print record.

ISBN:

9781942270591

1942270593