Access 2003 VBA Programming, 2nd Edition Study Guide

1-4239-1353-1 © 2007 Publish date: March 6, 2006 152 pages

Buy Now: $25.99

Course ID: access-2003-vba-prog-2nd-sg

If you are ready to take your advanced Access skills and learn how to use ActiveX data objects and control structures as well as get a foundation with the basics of VBA programming, the Access 2003 VBA Programming study guide is an excellent choice. This is one of our computer training books designed to teach you advanced techniques for working with Microsoft Access 2003.

ProCert Labs has awarded this Access 2003 VBA Programming courseware a 4.8/5.0 rating for overall quality. By choosing this book, you can learn these skills following a schedule of your own design. This is a self-directed course that should take about a day of dedicated studies to complete. However, because you are participating in a self-study course, you can spread out your instruction to suit your own needs.

The Access 2003 VBA Programming will introduce you to the Visual Basic Editor, programming basics, control structures, ActiveX data objects, and VBA debugging tools. You will learn how to use these features and how to integrate Access with other Microsoft Office applications such as MS Word and MS Excel.

This course builds on your existing, advanced Microsoft Access skills and teaches you basic programming steps. You can continue using the book as reference material long after completing the course.

Course Objectives

By choosing this courseware, you will learn how to use objects, Object Browser, collection objects, and the Controls collection. You'll learn about manipulating data by declaring variables, combining data with expressions, create Sub and Function procedures, get user input, and call one procedure from another. Other topics include using decision and loop structures, working with ActiveX Data Objects architecture and collections, connecting to databases, using Recordsets, and creating parameter queries. Finally, you will learn about compile-time, run-time, and logical error as well as using debugging tools and writing error-handling code.

Course Contents

Unit 1 introduces Visual Basic Editor

• Objects
• Object Browser
• Collections

Unit 2 covers the basics of programming

• Data
• Scope
• Unit 3 discusses control structures
• Decision structures
• Loop structures

Unit 4 covers ActiveX Data Objects

• Basics of ActiveX Data Objects
• Using ActiveX Data Objects

Unit 5 discusses VBA debugging tools

• Errors in code
• Debugging techniques
• Handling run-time errors

Appendix A discusses integrating with MS Office

• Automating Office 2003
• Accessing Word from Access
• Using Excel from Access