Microsoft Access VBA 2003/2007/2010 Training Belfast NI

Sponsored links

This 2 day course is suitable for Advanced users of Microsoft Access responsible for managing very large and variable amounts of data, or teams, who want to learn how to program features and functions to improve the accessibility and usability of their data.

Prerequisites:
A high proficiency of Microsoft Access is essential, or completion of our Advanced MS Access course.

Benefits:
At the end of the course the delegate will have covered the fundamentals of VBA, including working with procedures and functions, understanding objects, using expressions, variables and intrinsic functions. They will have mastered how to control program execution, working with forms and controls, working with the PivotTable object. Finally the course also includes modules on debugging code, handling errors to ensure minimal downtime while building and effecting the program.

Delivery:
  • Classroom
Regions:
  • Northern Ireland
Category:

Further Details

Course Content
The VBA Programming Environment

· When to use Visual Basic for Applications instead of Macros

· Visual Basic for Applications Development Environment



Programming in the VBA Language Code Compilation

· Finding Bugs



Error Handling in VBA

· Ignoring Errors

· Trapping Errors

· Writing Useful Error Handlers



Class Modules and Form-Event Procedures

· Using Form Events

· Code Behind Forms

· Changing Form Properties

· Creating New Form Instances



Manipulating Data through Data Access Objects and SQL

· Data Access Objects (DAO)

· Opening Databases Programmatically

· Database and Recordset Objects

· Manipulating Data with VBA Methods

· Finding Records in a Recordset

· Editing Data in a Recordset

· Using Recordsets to Manipulate Imported Data

· Creating, Using and Deleting Queries from VBA



Changing Database Definitions through VBA

· Using SQL to Manipulate Databases


This Training Course is taught in classrooms in the following locations:
Belfast

Guide Price: Please contact for details