Access 2007, VBA
In previous levels, you were introduced to advanced topics that dealt with local database management. In this course, you will learn remote database management, how to exchange data with XML and other type applications, and how to automate your business processes by using VBA code.
Audience
The target student for this course should be familiar with Access 2007 and Visual Basic for Applications. Students should be able to use various VBA programming elements. Students get the most out of this course, if their goal is to become proficient in working with objects and collections, and implementing ActiveX Data Objects.
To ensure the successful completion of Microsoft Office Access 2007: VBA, the following courses or equivalent knowledge is recommended: Microsoft Office Access 2007: Introduction, Microsoft Office Access 2007: Intermediate
Upon successful completion of this course, students will be able to:
- Work with objects, use Object Browser, identify collection objects, and use the Controls collection.
- Manipulate data by declaring variables, combine data by using expressions, get user input, create Sub and Function procedures, and call one procedure from another.
- Use decision structures and use loop structures.
- Identify ActiveX Data Objects (ADO) architecture and collections, connect to a database, work with a Recordset, and create a parameter query.
- Identify compile-time, run-time, and logical errors; use the debugging tools; and write error-handling code.
- CertBlaster preparation and materials also included.
- Unit 1: Visual Basic Editor
- Unit 2: Programming basics
- Unit 3: Control Structures
- Unit 4: ActiveX Data Objects
- Unit 5: VBA debugging tools
- Unit 6: Office integration
In order for a class to be successful, all students should share the same general level
of knowledge and experience. If a participant does not demonstrate these, the instructor will take
the necessary steps either to prepare the participant or place him/her in a more appropriate course.
This policy is intended to maintain the high level of quality control that you have come to expect.