Course Search:

Request more details:


Access 2007: VBA Programming

Description:
This course is designed for experienced Access users who want to learn ActiveX data objects, control structures, and the basics of VBA programming.
  • Cost: Price on application
  • Duration: 1 day
  • This course is not available as part of our public schedule but can be provided on a customised client specific basis.
Prerequisites:
VBA programming for MS Applications
Visual Basic Editor:
Objects
Object Browser
Collections
Programming basics:
Working with data
Scope
Control structures:
Decision structures
Loop structures
ActiveX Data Objects:
Getting started with ActiveX Data Objects
Working with ActiveX Data Objects
VBA debugging tools:
Errors in code
Debugging techniques
Handling runtime errors
Office integration:
Automating Office 2007
Working with Word from Access
Working with Excel from Access


Dublin: 01 6627700 - Cork: 021 4319010 - Limerick: 061 311982

© Professional Training Solutions Limited 1996-2012
CRO No. 252390 - Unit 22, Westland Square, Pearse Street, Dublin 2, Ireland.