Hour 23. VBA Introduced

The Visual Basic for Applications (VBA) language is at the heart of every Access application you write. VBA is the key to taking Access beyond the world of wizards into a world where anything is possible. This hour introduces you to the VBA language, which serves as a foundation for any programming code that you write. After following along with the text in the hour, you will be familiar with the development environment. In this hour you'll learn the following:

What VBA is
How to declare and work with variables
How to utilize control structures
How to pass parameters and return values
How to execute commands with the DoCmd object
How to work with built-in functions

Part I: Introduction to Relational Databases and Access 2003

Part II: Working with Existing Databases and Objects

Part III: Creating Your Own Database and Objects

Part IV: Power Access Techniques

Part V: Advanced Topics

Hour 18. Sharing Data with Other Applications

Hour 19. Access and the Internet

Hour 20. Database Administration

Hour 21. Database Documentation

Hour 22. Security Introduced

Hour 23. VBA Introduced

Access Class Modules, Standard Modules, Form Modules, and Report Modules

Working with Variables

Adding Comments to Code

Using the Line Continuation Character

Using the VBA Control Structures

Passing Parameters and Returning Values

The 'DoCmd' Object: Performing Macro Actions

Working with Built-in Functions

Hour 24. Finishing Touches