Access VBA Programming

Microsoft Access VBA Programming

Our aim is to provide you with an introduction to Access Objects, allowing you to make the most of your VBA skills. This course is applicable to Access 2003, 2007, 2010 and 2013.

Audience

Access VBA Programming is designed for experienced Access users who want to learn ActiveX data objects, control structures, and the basics of VBA programming.

Prerequisites

Before attending this course, students must have:
• Taken the Windows XP Level 1 course or have the basic skills and knowledge of Windows applications
• Taken Microsoft Access Levels 1, 2 and 3 or have equivalent knowledge and skills

(While it isn’t required, it’s recommended that you have experience with Microsoft Word and Excel.)

Objectives:
• Learn ActiveX data objects.
• Control structures.
• Basics of VBA programming.

Course Outline

Lesson 1: Visual Basic Editor
• Objects
• Object browser
• Collections

Lesson 2: Programming Basics
• Data
• Scope

Lesson 3: Control Structures
• Decision structures
• Loop structures

Lesson 4: ActiveX Data Objects
• Getting started with ActiveX data objects
• Working with ActiveX data objects

Lesson 5: VBA Debugging Tools
• Errors in code
• Debugging techniques
• Handling run-time errors

Appendix A: Office Integration
• Automating Office
• Working with Word from Access
• Working with Excel from Access

Length of Class: 
1 Day
Instructor-led or Online: 
Instructor-Led