Access 2024 / Microsoft 365 Programming by Example.

Format:

Book

Author/Creator:

Korol, Julitta.

Language:

English

Physical Description:

1 online resource (1200 pages)

Edition:

1st ed.

Place of Publication:

Herndon, VA : Mercury Learning & Information, 2025.

Summary:

Transform your Access databases from simple data repositories to powerful, automated applications with Access 2024 / Microsoft 365 Programming by Example. This isn't just another reference manual; it's a practical, step-by-step tutorial designed to guide you through the essentials of Visual Basic for Applications (VBA) within the Access environment. Built for those who already understand basic Access database design and operations, this book dives straight into practical examples and hands-on exercises. Each chapter builds upon the previous, gradually introducing you to more complex concepts and techniques. You'll learn how to automate tasks, enhance functionality, and create robust applications that streamline your workflow. Each chapter includes integrated ChatGPT sections, providing on-the-spot explanations, code examples, and answers to frequently asked questions. This AI-powered assistance transforms your learning experience, making complex concepts more accessible and helping you overcome challenges with ease. This book is perfect for Access users who are ready to take their skills to the next level. Whether you're a beginner looking to start programming or an experienced user aiming to refine your abilities, this tutorial provides a structured and approachable learning path. This book assumes you have a working knowledge of Microsoft Access, including database design, query creation, and form development with subforms and controls. Empower your Access skills today and build the applications you've always envisioned!

Contents:

Intro

Title Page

Copyrightpage

Contents

Acknowledgments

Introduction

List of Figures

List of Tables

Part I Access VBA Primer

Chapter 1 Introduction to VBA Programming

Statements, Commands, and Instructions

Procedures and Modules

Module Types

Procedure Types

Writing Procedures in a Module

Executing Your Procedures

Compiling and Saving Your Procedures

Placing a Database in a Trusted Location

VBA Data Types

Understanding and Using Variables

Declaring Variables

Specifying the Data Type of a Variable

Using Data Type Declaration Characters

Assigning Values to Variables

Forcing Declaration of Variables

Understanding the Scope of Variables

Procedure-Level (Local) Variables

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

Using Static Variables

Using Object Variables

Disposing of Object Variables

Finding a Variable Definition

Determining the Data Type of a Variable

Using Constants

Using ChatGPT with Access

Summary

Chapter 2 Getting to Know Visual Basic Editor (VBE)

Understanding the Project Explorer Window

Understanding the Properties Window

Understanding the Code Window

Other Windows in VBE

Assigning a Name to the VBA Project

Renaming a Module

Syntax and Programming Assistance

List Properties/Methods

Parameter Info

List Constants

Quick Info

Complete Word

Indent/Outdent

Comment Block/Uncomment Block

Using the Object Browser

Using the VBA Object Library

Using the Immediate Window.

Using ChatGPT with Access

Chapter 3 Access VBA Procedures and Functions

Writing Function Procedures

Running Function Procedures

Data Types and Functions

Passing Arguments (ByRef and ByVal)

Using Optional Arguments

VBA Built-In Functions for User Interaction

Using the MsgBox Function

Returning Values from the MsgBox Function

Using the InputBox Function

Converting Data Types

Chapter 4 Adding Decisions to Your Access VBA Programs

Relational and Logical Operators

If…Then Statement

Multiline If…Then Statement

Decisions Based on More than One Condition

If…Then…Else Statement

If…Then…ElseIf Statement

Nested If…Then Statements

Select Case Statement

Using Is with the Case Clause

Specifying a Range of Values in a Case Clause

Specifying Multiple Expressions in a Case Clause

Chapter 5 Adding Repeating Actions to Your Access VBA Programs

Using the Do…While Statement

Another Approach to the Do…While Statement

Using the Do…Until Statement

Another Approach to the Do…Until Statement

Using the For…Next Statement

Using the For Each…Next Statement

Exiting Loops Early

Nested Loops

Chapter 6 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 the For…Next Loop

Using a One-Dimensional Array

Arrays and Looping Statements

Using a Two-Dimensional Array

Static and Dynamic Arrays

Array Functions

The Array Function

The IsArray Function

The Erase Function

The LBound and UBound Functions.

Errors in Arrays

Parameter Arrays

Passing Arrays to Function Procedures

Sorting an Array

Chapter 7 Keeping Track of Multiple Values Using Collections

Creating Your Own Collection

Adding Items to Your Collection

Determine the Number of Items in Your Collection

Accessing Items in a Collection

Removing Items from a Collection

Updating Items in a Collection

Returning a Collection from a Function

Collections vs. Arrays

Watching the Execution of Your VBA Procedures

Chapter 8 Ge tting to Know Built-In Tools for Testing and Debugging

Syntax, Runtime, and Logic Errors

Stopping a Procedure

Using Breakpoints

Removing Breakpoints

Using the Immediate Window in Break Mode

Working in a Code Window in Break Mode

Using the Stop Statement

Using the Assert Statement

Using the Add Watch Window

Removing Watch Expressions

Using Quick Watch

Using the Locals Window

Using the Call Stack Dialog Box

Stepping Through VBA Procedures

Stepping over a Procedure

Stepping out of a Procedure

Running a Procedure to Cursor

Setting the Next Statement

Showing the Next Statement

Navigating with Bookmarks

Stopping and Resetting VBA Procedures

Trapping Errors

Using the Err Object

Procedure Testing

Setting Error-Trapping Options

Using Toolbars in the VBE Window

Part II Access VBA Programming with DAO and ADO

Chapter 9 Data Access Technologies in Microsoft Access

Introduction to Database Engines

Types of Database Engines

Understanding Access Versions and File Formats

Understanding Library References

Overview of Object Libraries in Microsoft Access

The VBA Object Library

The Microsoft Access 16.0 Object Library

OLE Automation.

The Microsoft Office 16.0 Access Database Engine Object Library

The Microsoft DAO 3.6 Object Library

The Microsoft ADO 6.1 Library

Creating a Reference to the ADO Library

Understanding Connection Strings

Using ODBC Connection Strings

Creating and Using ODBC DSN Connections

Creating and Using DSN-Less ODBC Connections

ODBC Connection Strings for Common Data Sources

Using OLE DB Connection Strings

Connection Strings via a Data Link File

Chapter 10 Creating and Manipulating Databases with DAO

Setting Up Your Environment for DAO Programming

Exploring the DAO Object Model

Creating a Database with DAO

Copying a Database

Opening Microsoft Access Databases

Opening a Microsoft Jet Database in Read/Write Mode

Opening a Microsoft Access Database in Read-Only Mode

Opening a Microsoft Jet Database Secured with a Password

Opening Other Files with DAO

Accessing Database Tables and Fields

Creating an Access Table and Setting Field Properties

Defining Various Types of Fields in an Access Table

Removing a Field from a Table

Retrieving Table Properties

Linking a dBASE Table

Creating Indexes

Adding a Multiple-Field Index to a Table

Introduction to DAO Recordsets

Opening a Recordset and Transferring Data

Finding and Reading Records with DAO

Counting Records and Retrieving Field Values

Using the Seek Method to Find Records in a Table-Type Recordset

Using the Find Methods to Find Records in Snapshots and Dynasets

Adding a New Record to a Table

Adding and Deleting Attachments

Adding Values to Multvalue Lookup Fields

Modifying a Record

Deleting a Record

Filtering Records

Copying Records to an Excel Worksheet

Introduction to Queries

Operators, Wildcards, and Predicates Used in Queries.

Creating a Select Query with DAO

Creating and Running a Parameter Query

Creating and Running a Make-Table Query

Creating and Running Update, Append, and Delete Queries

Creating and Running a Pass-Through Query

Performing Other Operations with Queries

Transaction Processing

Creating a Transaction with DAO

Chapter 11 Creating and Manipulating Databases with ADO

Setting Up Your Environment for ADO Programming

Creating an Access Database with ADO

Copying a Database with FileSystemObject

More About Database Errors

Connecting to the Current Access Database

Opening Other Databases, Spreadsheets, and Text Files

Connecting to an SQL Server Database

Opening a Microsoft Excel Workbook

Opening a Text File

Creating a Microsoft Access Table and Setting Field Properties

Copying a Table

Deleting a Table

Adding New Fields to an Existing Table

Retrieving Table and Field Properties

Linking a Microsoft Access Table

Linking a Microsoft Excel Worksheet

Listing Database Tables Using the Catalog Object

Listing Tables and Fields Using the OpenSchema Method

Listing Data Types

Retrieving the Value and the Increment of the AutoNumber Field

Creating a Primary Key Index

Creating a Single-Field Index

Listing Indexes in a Table

Deleting Table Indexes

Creating Table Relationships

Introduction to ADO Recordsets

Cursor Types

Lock Types

Cursor Location

The Options Parameter

Opening a Recordset

Opening a Recordset Based on a Table or Query

Opening a Recordset Based on an SQL Statement

Opening a Recordset Based on Criteria

Moving Around in a Recordset

Finding the Record Position.

Returning a Recordset as a String.

Notes:

Description based on publisher supplied metadata and other sources.

ISBN:

1-5015-2262-0

OCLC:

1521989602