01. Intro to Access VBA (8:42)
What is VBA
Visual Basic for Applications
Visual Studio
Visual Basic .NET
Benefits over Macros

02. Our First VBA Code (12:51)
Hello World
Turn off Project Explorer
Turn off Properties Window
Turn off Immediate Window
MsgBox Command
Parameters
Optional Parameters
Multiple Parameters
Keyword
Statement
Procedure
Subroutine
Function
Module

03. DoCmd.OpenForm (12:46)
Open Form Command
Arguments List
Where Condition
Open Specific Record
Duplicate Code
Preview of Creating Subs

04. Subs with Multiple Commands (5:59)
Archive Contacts Button
Docmd.SetWarnings
Docmd.OpenQuery
MsgBox Command

05. Add Product Button (12:01)
If Then Statement
End If
Else, ElseIf
Docmd.GoToControl
Docmd.GoToRecord acNewRec
SetValue in VBA

06. AfterUpdate Event (10:19)
Add New Customer Button
After Update Event
Always Use Event Procedures
Boolean Values TRUE is Assumed