Microsoft Access VBA

Level
Total time

Microsoft Access VBA

Aspect Training
Logo Aspect Training
Provider rating: starstarstarstarstar 9.8 Aspect Training has an average rating of 9.8 (out of 1 reviews)

Need more information? Get more details on the site of the provider.

Starting dates and places

There are no known starting dates for this product.

Aspect Training offers their products as a default in the following regions: Surrey

Description

Our public scheduled sessions are held in Leatherhead, Surrey and any of our courses can be run as a closed course on your site or on one of ours nationwide.

 

Aspect Training's Microsoft Office Access VBA training course builds on the skills you've already

developed in creating database applications learn on our previous Microsoft Access courses and

helps you take them to the next level—using Visual Basic for Applications (VBA) to accomplish things

you once performed manually. To facilitate this lofty goal, Access includes the VBA programming

language. Even if you've never programmed, Aspect Training's Microsoft Office Access VBA training

course will help you learn how to leverage the power of VBA to make your work with Access more

efficient than ever before. Aspect Training's Microsoft Office Access VBA training course is for

professionals…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Our public scheduled sessions are held in Leatherhead, Surrey and any of our courses can be run as a closed course on your site or on one of ours nationwide.

 

Aspect Training's Microsoft Office Access VBA training course builds on the skills you've already

developed in creating database applications learn on our previous Microsoft Access courses and

helps you take them to the next level—using Visual Basic for Applications (VBA) to accomplish things

you once performed manually. To facilitate this lofty goal, Access includes the VBA programming

language. Even if you've never programmed, Aspect Training's Microsoft Office Access VBA training

course will help you learn how to leverage the power of VBA to make your work with Access more

efficient than ever before. Aspect Training's Microsoft Office Access VBA training course is for

professionals who use Microsoft Access frequently in their daily work. You have serious work to get

done and this course teaches you the essential skills you need to automate your databases as quickly

as possible.

Course Topics:

Getting Started

Introduction to access programming

Understanding the development

environment

Using VB help

Developing with Procedures and

Functions

Understanding and creating modules

Defining procedures

Creating a sub-procedure

Calling procedures

Utilising the immediate window to call

procedures

Making and naming a function procedure

Working using the code editor

Understanding Objects

Understanding classes and objects

Navigating the Access object hierarchy

Understanding collections

Using the object browser

Working with the application object

Understanding the form object

Working with properties

Using the with statement

Working with methods

Understanding the DoCmd object

Working with events

Understanding the order of events

Utilising Intrinsic Functions, Variables

and Expressions

Defining expressions and statements

How to declare variables

Determining data types

Programming with variable scope

Harnessing intrinsic functions

Defining constants and using intrinsic

constants

Adding message boxes and using input

boxes

How to declare and use object variables

Controlling Program Execution

Understanding control-of-flow structures

Working with boolean expressions

Using the if...end if decision structures

Using the select case...end select structure

Using the for...next structure

Using the for each...next structure

Using the do...loop structure

Guidelines for use of branching structures

Working with Recordsets

Declaring and creating object variables

Working with the ADODB recordset object

Specifying a recordset cursor type

Locking records for updating

Specifying a recordset cursor location -

optional

Using the cache size property - optional

Understanding recordset cursor properties

- optional

Debugging the Code

Defining errors

Working with debugging tools

Determining breakpoints

How to step through code

Working with break mode during run mode

Identifying the value of expressions

Handling Errors

Understanding error handling

Understanding VBA's error trapping

options

Trapping errors with the on error

statement

Understanding the error object

Writing an error handling routine

Working with inline error handling

There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.