Programming Microsoft Access
An Introduction to Visual Basic for Applications
(Supplemental to Microsoft Access
for Beginners)
Updated May 2010
This series is written for those new to Visual Basic for Applications (VBA), the language used for scripting within Microsoft Access. It is also intended as a general introduction to programming concepts. Before using this series, readers should be familiar with the basics of database design in Microsoft Access.
Demonstration Files
Demo.zip ( Download ) - Access demonstration database and original Excel spreadsheet (Requires Access and Excel 2000 or later)
Chapters
- Introduction
What is Visual Basic for Applications? How and why is it used with Microsoft Access? - The VBA Environment
An explanation of the programming environment and its tools. - Variables
Storing information in memory and referencing it for use in code. - Procedures
The basic units of code; methods, functions and custom properties. - Arrays and Enumerations
Taking variables to the next level by grouping them into arrays and enumeration types. - Operators
Mathematical, logical and other symbols available for use in VBA formulas. - DoCmd
Unique to VBA, this keyword offers a wealth of shortcut methods. - Decision Structures
Writing dynamic code that can make decisions on the fly. - Loops
Looping structures enable you to repeat a series of actions as many times as needed. This chapter demonstrates both numbered and conditional loops. - Algorithms
Beyond commands and syntax, this chapter explains how to design a solution and turn it into code.
For more information:
Access 2007 VBA Programmer's Reference (Programmer to Programmer)
Available on
Amazon.com
Comments
and questions are welcome. Your input can help to improve these
articles for everyone!
