Access 2021 / Microsoft 365 Programming by Example
- 14h 55m
- Julitta Korol
- Mercury Learning
- 2022
Updated for Access 2021 and based on the bestselling editions from previous versions, Access 2021 / Microsoft 365 Programming by Example is a practical, how-to book on Access programming, suitable for readers already proficient with the Access user interface (UI). If you are looking to automate Access routine tasks, this book will progressively introduce you to programming concepts via numerous illustrated hands-on exercises. More advanced topics are demonstrated via custom projects. With concise and straightforwardexplanations, you learn how to write and test your programming code with the built-in Visual Basic Editor; understand and use common VBA programming structures such as conditions, loops, arrays, collections and dictionaries; code a "message box"; reprogram characteristics of a database; and use various techniques to query and manipulate your Access .mdb and .accdb databases. The book shows you how you can build database solutions with Data Access Objects (DAO) and ActiveX Data Objects (ADO); define database objects and manage database security with SQL; enhance and alter the way users interact with database applications with Ribbon customizations and event programming in forms and reports. You also learn how to use Access with XML and REST API. The book includes a comprehensive disc with source code, supplemental files, and color screen captures (also available from the publisher for download).
FEATURES:
- Contains 28 chapters loaded with illustrated "Hands-On" exercises and projects that guide you through the VBA programming language. Each example tells you exactly where to enter code, how to test it and run it.
- Explains how to store data for further manipulation in variables, arrays, collections, and in a VBA Dictionary object while teaching you to write both simple and complex VBA programming routines and functions.
- Teaches you how to programmatically create and access database tables and fields, enforce data integrity and relationships between tables.
- Includes a comprehensive disc with source code, supplemental files, and color screen captures (also available from the publisher for download).
About the Author
Julitta Korol is a software consultant who delivers custom-tailored hands-on training and develops advanced database and spreadsheet applications. She has written over 20 computer books including Microsoft Excel 2013 Programming with VBA, XML and ASP (Mercury Learning). She lives on Long Island, New York.
In this Book
-
Introduction
-
Getting Started with Access VBA
-
Getting to Know Visual Basic Editor (VBE)
-
Access VBA Fundamentals
-
Access VBA Built-In and Custom Functions
-
Adding Decisions to Your Access VBA Programs
-
Adding Repeating Actions to Your Access VBA Programs
-
Keeping Track of Multiple Values Using Arrays
-
Keeping Track of Multiple Values Using Collections
-
Getting to Know Built-In Tools for Testing and Debugging
-
Data Access Technologies in Microsoft Access
-
Creating and Manipulating Databases with DAO
-
Creating and Manipulating Databases with ADO
-
Creating, Modifying, and Deleting Tables and Fields
-
Enforcing Data Integrity and Relationships between Tables
-
Defining Indexes, and Primary Keys
-
Views and Stored Procedures
-
Implementing Database Security with DDL
-
Implementing User-Level and Share-Level Security
-
Enhancing Access Forms
-
Using Form Events
-
Events Recognized by Form Controls
-
Enhancing Access Reports and Using Report Events
-
Customizing the Menu System in Access
-
Creating Classes in VBA
-
Advanced Event Programming
-
Macros and Templates
-
XML Features in Access 2021
-
Access and REST API
