Access 2000 Programming with VBA
MTC -
2 days - Advanced - In-House - £595
Course Code: MTC26
Send A Message
Description and objective: Getting Started
Introduction to Programming in Access
Why Program in Access?
Creating a Macro
Understanding Modules
Creating a Standard Module
Understanding the Development Environment
Using the Project Explorer
Using the Properties Window
Using the Code Window
Working with Procedures and Functions
Understanding Procedures
Creating a Sub Procedure
Creating a Function Procedure
Calling Procedures and Functions
Using the Immediate Window
Working with Code
Understanding Objects, Properties, Methods and Events
Understanding Objects and Collections
Understanding Properties
Understanding Methods
Understanding Events
Understanding the Access Object Hierarchy
Understanding Access Objects
Using the Object Browser
Controlling the Application Object
Understanding the Forms Collection and Form Object
Understanding the Controls Collection and Control Object
Using the With Statement
Understanding the Reports Collection and Report Object
Understanding the DoCmd Object
Using the Screen Object
Using Variables, Arrays, and Constants
Declaring Variables
Declaring Arrays
Declaring Constants
Declaring Object Variables
Using Functions, Message Boxes, and Input Boxes
Using Intrinsic Functions
Using Message Boxes
Using Input Boxes
Controlling Program Execution
Using Control Structures
Working with Conditional Expressions
Using the If...Then...End If Structure
Using the If...Then...Else...End If Structure
Using the Select Case...End Select Structure
Using the Do...Loop Structure
Using the For...Next Structure
Debugging Code
Understanding Errors
Using Debugging Tools
Stepping Through Code and Setting Break Points
Understanding Error Events
Understanding the Err Object
Using the On Error Statement
Writing an Error Handling Routine
Compiling All Procedures
Contact MTC
| Phone | 01915153355 When calling be sure to mention Training Pages
| Fax | 01915153350 |
|
Send a Message
Back to Top