Access: VBA

Learn how to leverage the Visual Basic for Applications (VBA) programing language in Access to create robust desktop database applications.

Introduction

• Get the most out of Microsoft Access with VBA
• What you should know

1. Introduction to Visual Basic for Applications

• Introduction to object-oriented programming
• Examine the Access object model
• Work in the Visual Basic Editor
• Create, export, and delete code modules
• Create a subroutine
• Create a function
• Add comments to your code
• Run a VBA procedure

2. Define Variables, Constants, and Calculations

• Introduction to Access data types
• Declare variables and require declaration before using
• Manage variable scope
• Define constants and static variables
• Create a calculation using mathematical operators
• Display a calculated result in a message box
• Define an array
• Define and use an object variable

3. Add Logic to Your VBA Code

• Repeat a task using a For…Next loop
• Step through all items of a collection using a For…Each loop
• Repeat a task using a Do…While loop
• Perform a task when conditions are met using an If…Then statement
• Select actions using a Case statement

4. Debug Your VBA Code

• Manage errors in VBA code using On Error statements
• Step through a subroutine or function
• Set breakpoints in your code
• Verify output using the Immediate window
• Watch a value in a routine

5. Manipulate Database Objects Using DoCmd

• Open a form
• Open a report
• Open a table
• Open a query
• Close an object
• Close a database or quit Access
• Run a menu command
• Print the active database object
• Display or hide warnings

6. Read and Manipulate Table Data

• Display every row in a table (recordset)
• Add a new record to a table
• Edit values in an existing table row
• Preserve data integrity using transactions
• Display a table property using the TableDef object
• Close a recordset
• Delete the current record
• Find records within a table
• Move within a recordset
• Count the records in a recordset

7. Manipulate a Database Using the Application Object

• Summarize values in a table field
• Find the first or last value in a table field
• Look up a value in a table field
• Create a progress bar using the SysCmd object

8. Control Forms and Reports Using the Me Object

• Allow or disallow additions, deletions, and edits
• Manipulate form filters
• Set the caption and background picture
• Requery and repaint forms
• Discover a record source
• Render a form or report visible or invisible

9. Automate Processes Using Macros

• Introduction to Access macros and data macros
• Create macros
• Work with data macros
• Run a macro by clicking a command button
• Manage macro security settings

Conclusion

• Next steps