Course Overview
This ILT Series course, rated 4.9/5.0 in overall quality by ProCert Labs, is designed for experienced Access 2007 users who want to learn ActiveX Data Objects, control structures, and the basics of VBA programming. Comes with CertBlaster pre- and post-assessment software (download).
Audience Profile
This course is designed for any knowledge worker or business professional who needs to learn to use VBA within Microsoft Access 2007.
At Course Completion
After completing this course, students will be able to:
- customize the Windows 7 environment.
- configure user accounts.
- work with applications in Windows 7.
- work with devices.
- manage networks.
- secure your system data.
- enhance system performance.
- work with Internet Explorer 8.
Course Outline
Unit 1: Visual Basic Editor
- Objects
- Object Browser
- Collections
Unit 2: Programming basics
- Working with data
- Scope
- Unit 3: Control structures**
- Decision structures
- Loop structures
Unit 4: ActiveX Data Objects
- Getting started with ActiveX Data Objects
- Working with ActiveX Data Objects
Unit 5: 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
Prerequisites
Before attending this course, the student should have
- Expertise in Microsoft Access 2007