Microsoft Access 2003 VBACourses > Microsoft Office Training > Microsoft Office 2003 > Microsoft Access 2003 VBA

  • strict warning: Non-static method view::load() should not be called statically in /home3/indiciat/public_html/sites/all/modules/views/views.module on line 1113.
  • strict warning: Declaration of views_handler_argument::options_validate() should be compatible with views_handler::options_validate($form, &$form_state) in /home3/indiciat/public_html/sites/all/modules/views/handlers/views_handler_argument.inc on line 917.
  • strict warning: Declaration of views_handler_argument::query() should be compatible with views_handler::query($group_by = false) in /home3/indiciat/public_html/sites/all/modules/views/handlers/views_handler_argument.inc on line 917.
  • strict warning: Declaration of views_handler_sort::options_validate() should be compatible with views_handler::options_validate($form, &$form_state) in /home3/indiciat/public_html/sites/all/modules/views/handlers/views_handler_sort.inc on line 165.
  • strict warning: Declaration of views_handler_sort::options_submit() should be compatible with views_handler::options_submit($form, &$form_state) in /home3/indiciat/public_html/sites/all/modules/views/handlers/views_handler_sort.inc on line 165.
  • strict warning: Declaration of views_handler_sort::query() should be compatible with views_handler::query($group_by = false) in /home3/indiciat/public_html/sites/all/modules/views/handlers/views_handler_sort.inc on line 165.
  • strict warning: Declaration of views_handler_filter::options_validate() should be compatible with views_handler::options_validate($form, &$form_state) in /home3/indiciat/public_html/sites/all/modules/views/handlers/views_handler_filter.inc on line 587.
  • strict warning: Declaration of views_handler_filter::query() should be compatible with views_handler::query($group_by = false) in /home3/indiciat/public_html/sites/all/modules/views/handlers/views_handler_filter.inc on line 587.
  • strict warning: Declaration of views_handler_filter_node_status::operator_form() should be compatible with views_handler_filter::operator_form(&$form, &$form_state) in /home3/indiciat/public_html/sites/all/modules/views/modules/node/views_handler_filter_node_status.inc on line 13.
  • strict warning: Declaration of views_plugin_argument_validate::options_submit() should be compatible with views_plugin::options_submit($form, &$form_state) in /home3/indiciat/public_html/sites/all/modules/views/plugins/views_plugin_argument_validate.inc on line 87.
  • strict warning: Declaration of views_plugin_argument_validate_taxonomy_term::options_submit() should be compatible with views_plugin_argument_validate::options_submit(&$form, &$form_state) in /home3/indiciat/public_html/sites/all/modules/views/modules/taxonomy/views_plugin_argument_validate_taxonomy_term.inc on line 165.
  • strict warning: Non-static method view::load() should not be called statically in /home3/indiciat/public_html/sites/all/modules/views/views.module on line 1113.
  • strict warning: Non-static method view::load() should not be called statically in /home3/indiciat/public_html/sites/all/modules/views/views.module on line 1113.
  • strict warning: Non-static method view::load() should not be called statically in /home3/indiciat/public_html/sites/all/modules/views/views.module on line 1113.
  • strict warning: Non-static method view::load() should not be called statically in /home3/indiciat/public_html/sites/all/modules/views/views.module on line 1113.
  • strict warning: Non-static method view::load() should not be called statically in /home3/indiciat/public_html/sites/all/modules/views/views.module on line 1113.
  • strict warning: Non-static method view::load() should not be called statically in /home3/indiciat/public_html/sites/all/modules/views/views.module on line 1113.
  • strict warning: Non-static method view::load() should not be called statically in /home3/indiciat/public_html/sites/all/modules/views/views.module on line 1113.
  • warning: preg_replace(): Compilation failed: invalid range in character class at offset 11 in /home3/indiciat/public_html/sites/all/themes/indiciatraining/template.php on line 170.
  • warning: preg_replace(): Compilation failed: invalid range in character class at offset 11 in /home3/indiciat/public_html/sites/all/themes/indiciatraining/template.php on line 170.
  • warning: preg_replace(): Compilation failed: invalid range in character class at offset 11 in /home3/indiciat/public_html/sites/all/themes/indiciatraining/template.php on line 170.
  • warning: preg_replace(): Compilation failed: invalid range in character class at offset 11 in /home3/indiciat/public_html/sites/all/themes/indiciatraining/template.php on line 170.
  • warning: preg_replace(): Compilation failed: invalid range in character class at offset 11 in /home3/indiciat/public_html/sites/all/themes/indiciatraining/template.php on line 170.
  • warning: preg_replace(): Compilation failed: invalid range in character class at offset 11 in /home3/indiciat/public_html/sites/all/themes/indiciatraining/template.php on line 170.
  • warning: preg_replace(): Compilation failed: invalid range in character class at offset 11 in /home3/indiciat/public_html/sites/all/themes/indiciatraining/template.php on line 170.
  • warning: preg_replace(): Compilation failed: invalid range in character class at offset 11 in /home3/indiciat/public_html/sites/all/themes/indiciatraining/template.php on line 170.
Duration: 
2 days - £499
Course ID: 
n/a

At the end of the course the delegate will have covered the fundamentals of VBA. They will have mastered how to control program execution, working with forms and controls, working with the PivotTable object. The course also includes modules on debugging code, handling errors to ensure minimal downtime while building and effecting the program.This course is available on our new V-Learning platform or as an onsite/closed event.  Please call for details.

 

Microsoft Access 2003 VBA

 

 

Duration

 

2 days

 

 

Prerequisites

 

Delegates should have attended the appropriate introductory and advanced courses plus have several weeks of practice. No programming experience is required.This course is available on our new V-Learning platform or as an onsite/closed event.  Please call for details.

 

 

Course Content

 

Module 1

           Getting Started

           Introduction to Programming in Access

           Why Program in Access?

           Understanding the Development Environment

           Using Visual Basic Help

 

Module 2

           Working with Procedures and Functions

           Understanding Modules

           Creating a Standard Module

           Understanding Procedures

           Creating a Sub Procedure

           Calling Procedures

           Using the Immediate Window to Call Procedures

           Creating a Function Procedure

           Naming Procedures

           Organizing Code and Procedures

           Working with the Code Editor

 

Module 3

           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

 

Module 4

           Using Expressions, Variables, and Intrinsic Functions

           Understanding Expressions and Statements

           Declaring Variables

           Understanding Data Types

           Working with Variable Scope

           Working with Variable Lifetime

           Considering Variable Scope and Lifetime Together

           Using Intrinsic Functions

           Understanding Constants

           Using Intrinsic Constants

           Using Message Boxes

           Using Input Boxes

 

Module 5

           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

 

Module 6

           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 CacheSize Property - Optional

           Understanding Recordset Cursor Properties - Optional

 

Module 7

           Debugging Code

           Understanding Errors

           Using Debugging Tools

           Setting Breakpoints

           Setting Break Expressions

           Using Break Mode during Run Mode

           Stepping through Code

           Determining the Value of Expressions

 

Module 8

           Handling Errors

           Understanding Error Handling

           Understanding VBA's Error Trapping Options

           Trapping Errors with the On Error Statement

           Understanding the Err Object

           Writing an Error-Handling Routine

·            Working with Inline Error Handling

Please call 0141 221 5676 for course information and available dates or email us at info@indiciatraining.com.

Please contact us and we will be happy to offer further assistance.