Access VBA (2-days)
Sponsored links
Objectives: After completing this course, you will know how to: Work with objects, use the Object Browser, identify collection objects, and use the Controls collection. Manipulate data by declaring variables, combine data by using expressions, get user input, create Sub and Function procedures, and call one procedure from another. Use decision structures and loop structures. Identify ActiveX Data Objects (ADO) architecture and collections, connect to a database, work with a Recordset, and create a parameter query. Identify compile-time, run-time, and logical errors; use the debugging tools; and write error-handling code.
Prerequisites: This is a generic course and is suitable for users of any version of Microsoft Access. This course is particularly beneficial for those with a sound knowledge of Access who are familiar with other features available such as tables, queries, forms, reports, macros and relationships.
| Delivery: |
|
| Category: |
Further Details
Course Content:
Create powerful applications
Objects, Properties and Methods
Synchronising Forms
Storing Return Values
Learn basic programming structures
Working with Modules
Creating Sub Procedures
Calling Sub Procedures
Work with conditional statements and loops
The If Statement
The Do Command
Looping
Create custom message boxes
Evaluating a Message box
Responding to User Selections
Create Custom functions
Using Built-in Functions
Creating Custom Functions
Calling Function Procedures
Interact with Excel or Word
Opening Other Applications
Destroying Object Variables
Adding Data
Write error-handling code
Stepping Through Code
Using the Intermediate Window
Setting a Watch on a Variable
Validating User Input
Checking for Null Values
Offering Choices
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.
