Access VBA

On-Site Access VBA Training Course

If you or your team need on-site Microsoft Access VBA training in Sussex, Kent, Surrey and London, we can help. We offer Microsoft Access VBA training for versions 2003-2013, with the most popular ones being 2007, 2010 and 2013. We often visit clients in Croydon, Guildford, Brighton and Crawley. We would love to help you at your offices to ensure your staff are fully utilising Access VBA to improve productivity.

The Microsoft Access VBA training course below is an intensive course designer to introduce new Microsoft Access programmers to features and facilities of the VBA programming language. It is meant to help developers plan their applications systematically, efficiently and economically. We also offer bespoke/custom IT training for Microsoft Access VBA in Sussex, Kent, Surrey and London that will revolutionise the way your employees operate. Please call us on 01892 665 353 to talk through your business requirements or email us.

Download this course information as a PDF file

THE VBA PROGRAMMING ENVIRONMENT

  • When to use VBA instead of Macros ce Applications

PROGRAMMING IN THE VBA LANGUAGE

  • Coding in Visual Basic for Applications
  • Commenting Code
  • Line Continuation Character
  • Using Variables and Expressions
  • Naming Conventions
  • Defining Variables and Assigning Values
  • Automatic or Explicit Declarations
  • The Variant Data Type; Other Data Types
  • Branching and Looping commands
  • Indenting Code; Branching
  • If…Then; Select Case
  • Looping; For….Next
  • Do….Loop; For Each…..Next
  • Using Arrays and Collections
  • Typing in Code
  • Optional and Named Arguments
  • Passing Arrays as Arguments
  • Code Compilation
  • Conditional Compilation Directives
  • Finding Bugs; Types of Error
  • Debugging Code; Stepping Options
  • Watch Points and conditional Breakpoints

MANIPULATING DATA: DATA ACCESS OBJECTS & SQL

  • Data Access Objects; DAO Hierarchy
  • Working with Objects and Collections
  • Opening Databases Programmatically
  • Database and Recordset Objects
  • Recordset Objects and Recordset Fields
  • Dynasets and Snapshots
  • Manipulating Data with VBA Methods
  • Finding Records in a Recordset
  • Editing Data in a Recordset
  • Transaction processing Commands
  • Using Recordsets to Manipulate Data
  • Creating and Using Queries from VBA
  • Changing Database Definitions through VBA
  • Using SQL to Manipulate Databases
  • SQL Data Modification Statements
  • Methods of Running SQL from VBA Code

CLASS MODULES AND FORM-EVENT PROCEDURES

  • Creating a Class Module
  • Form Events and Properties
  • Changing Form Properties
  • Creating Validation Event Procedures
  • Creating New Form Instances
  • Using Form Class Modules

About Oregen Training

The go to supplier for effective IT training solutions.

For over 20 years we have been providing quality instructor led IT training to the corporate and small business market place ...

- read more

Contact Information

Telephone: +44 (0) 1892 665353
Email: info@oregentraining.com