Course content

Objects/Properties/Events/Methods·

• Different events· 
• Form events· 
• Control events· 
• Report events· 
• Attaching code

The Visual Basic Environment· 

• Steps to creating a VBA application· 
• Class modules· 
• Procedures· 
• Adding command buttons

Object Properties· 

• Object properties· 
• Setting properties at design time· 
• Setting properties at run time· 
• Using WITH

Event Procedures· 

• Writing event procedures· 
• Code structure· 
• Adding comments

Setting Keyboard Events· 

• Using KeyUp and KeyDown events

Statements And Functions· 

• Writing statements and functions· 
• Input boxes· 
• Message boxes

Variables· 

• Creating variables· 
• Naming conventions· 
• Data types· 
• Declaring more than one variable· 
• Concatenation· 
• Scope of variables 

Constants· 

• Declaring and using constants· 
• Scope of constants

Debugging· 

• Errors· 
• Compiling· 
• Setting breakpoints· 
• Working in break mode· 
• Debug tools

VB Error Handling · 

• Writing Error Handling Routines

Access Error Handling· 

• Replacing standard error message

Conditional Statements· 

• IF statement· 
• SELECT CASE statement· 
• Tests

General Procedures· 

• Scope of procedures· 
• Calling procedures·
• Sub procedures· 
• Standard modules

Function Procedures· 

• Creating functions· 
• Parameters or arguments· 
• Optional arguments· 
• Default values