Microsoft Access VBA Programming (Level 4) 2003 2007 2010
Sponsored links
VBA PROGRAMMING IN ACCESS – from Base2
– 2 days
After completing this course an attendee will be able to add Visual Basic coding to a Microsoft Access database.
A thorough understanding of Microsoft Access is essential.
| Delivery: |
|
| Regions: |
|
| Category: |
Further Details
1 VBA Development Environment
• When to use VBA
• Options
• Navigation
2 Creating Modules, Functions and Sub-routines
• New Modules
• Creating a Function or Procedure
• Passing Arguments and Returning values
3 Using Variables and Expressions
• Naming Conventions
• Declarations
• Assigning Values
4 Declaring Variables and Data Types
• Dimension Statement
• Data Types
5 Branching and Looping commands
• Indenting Code
• If … Then
• Select Case
• For … Next
• Do … Loop
6 Arguments
• Named and Optional
7 “Bugs"
• Types of Error
• Syntax or Logical
• Debug Window
• Breakpoints
• Using Message Boxes
8 Example Functions
• Text Functions
• Date Examples
9 Event Procedures on Forms
• Using the Builder
• Form Events and Properties
• Form Modules
• Validation Procedures
10 Writing Event Procedures
• Bespoke Functions
• Changing Controls
11 Trapping Errors
• On Error
• Error Codes
12 Manipulating Record Sets
• Opening Databases
• Recordset Objects
• Manipulating Data
• Finding Data
• Modifying Queries
This Training Course is taught in classrooms in the following locations:
Newcastle
Sunderland
Information provided is for information purposes only and no guarantees are made with regards to accuracy. It is advised that all details are checked prior to making a booking. Contents © 1999 - 2012. All rights reserved.
