Course Info

VBAPA - VBA Programming Using Access 2007

Categories Microsoft Access Training, Microsoft Office Training, Applications Training

Duration 1 day (7 hours)

Pre-requisites
MA2007-1 - Microsoft Access 2007: Introduction, MA2007-2 - Microsoft Access 2007: Intermediate and MA2007-3 - Microsoft Access 2007: Advanced, or equivalent knowledge and experience.

Courseware VBAPA-TL-01 (100 pages)

Price $295

Notes

This course is designed for experienced Access 2007 users who want to learn ActiveX Data Objects, control structures, and the basics of VBA programming.

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
Appendix A: Office integration
      Automating Office 2007
      Working with Word from Access
      Working with Excel from Access