What you’ll learn

Access VBA Programming Basics

• Getting help in VBA
• Create a subroutine
• Create a function
• Declare a variable
• Create a constant
• Comment your code
• Objects, Properties and Methods 
• Collections and Objects 
• Using Exclamation Marks, Dots & Brackets

The VB code editor

• Using Project Explorer
• Creating modules
• Using Immediate Window

Working with Access Objects

• What is an object in VBA
• Objects Properties
• Objects Properties
• AccessObject Object
• Using an Object Variable
• The Me Property
• Application Objects
• Assign Values to Variables

Loops and conditions

• Simple IF conditions
• Multiple IF and SELECT … CASE
• While Loop
• Execute tasks a specific number of times
• Using the For Each Next Loop
• Jump to a specific location in a Macro

Looping over collections

• Object variables
• Looping over collections

Using built-in functions and statements

• Using the MsgBox function
• Using the InputBox function
• Create and using custom functions

Working with Data Object Model

• Understanding DAO and ADO 
• ADO Object Model 
• Working with RecordSets 
• Creating a RecordSet 
• Close the RecordSet 
• Finding Specific Records
• RecordSet Boundaries
• Moving through a RecordSet
• Filtering a RecordSet
• Editing Data in a RecordSet 
• Adding a New Record 
• Deleting Records

Error Handling Techniques

• On Error statement
• Resuming after an error
• Identifying specific errors