Microsoft Access 2007: VBA Programming

Course Overview

This course provides delegates with an overview Access VBA. Rather than being a formal "learning to programme" course, this is a hands-on, task-based course which tackles some common problems and shows how they can be overcome with a little knowledge of VBA.

All of our Microsoft delivery partners providers and specialist Microsoft trainers have met our tough rigorous guidelines and we constantly monitor the quality of our Microsoft training to ensure that your needs are met and only the highest quality Microsoft courses are provided.

Related Courses

• Microsoft Access 2007: Introduction for Beginners (2 day)
• Microsoft Access 2007: Building Applications with microsoft Access
• Microsoft Access 2007: Introduction for Beginners (1 day)
• Microsoft Access 2007: Advanced (1 day)
• Microsoft Access 2007: Level 4 (1 day)
• Microsoft Access 2007: Intermediate (1 day)
• Microsoft Access 2007: Advanced
• Microsoft Access 2007: Introduction for Beginners
• Microsoft Access 2007: Intermediate
• Microsoft Access 2007: Introduction and Intermediate

Prerequisites

Delegates should have a good knowledge of Microsoft Access, including creating tables, forms, reports and queries. A knowledge equivalent to the Advanced Access course is assumed.

Course Outline

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