Find Courses Find Providers Providers - Promote Your Courses About Us

Access VBA (2-days)

Training Courses

Would you like to see more Microsoft Access courses?

Training course summary

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.
Regions:
  • All Areas
Delivery:
  • In House
  • Public
  • Computer Based
Category:
Difficulty:
  • Introductory

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

Guide price

£550 per person (public course)

 

Sponsored links

Interested in this course?

 

 
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. Terms of use
Website design by Brit-net