This training CD-ROM allows Access users to advance to the next level by using Visual Basic for Applications (VBA). From learning total control of coding to employing various variables and spotting errors, this resource provides a solid foundation for those who want to develop Access databases.
Learn how to make VBA work more efficiently with Access 2007 to automate your databases and accomplish tasks performed manually.
Designed as a Training Tool
This training CD-ROM allows Access users to advance to the next level by using Visual Basic for Applications (VBA). From learning total control of coding to employing various variables and spotting errors, this resource provides a solid foundation for those who want to develop Access databases.Learn how to make VBA work more efficiently with Access 2007 to automate your databases and accomplish tasks performed manually.
Completely Visualized!
Containing more than 1,110 step-by-step slides, this user-friendly guide ensures total absorption of the material by encouraging a self-paced training program.
Self-Paced with Self-Checks!
Click through the slides at your own pace. Every few slides, there will be a multiple choice question to ensure you've mastered recent concepts. These are the same concepts taught during Dr. Verschuuren's Excel Seminars. If you can't schedule Gerry at your office, then the next best thing is to buy this CD!
Click here to order the CD!
Look at everything you will learn!
You get three complete modules on the CD covering 1150 slides. Part 1
1. Object-Oriented
- Object Browser
- Properties and Events
- Subs and Functions
2. Code Control
3. Variables
- Value Data Type
- Collections
- Object Data Type
4. Loops
- Do Loops
- For Loops
- For-Each Loops
5. Error Handling
Part 2
1. Custom Procedures
- Custom Subs
- Custom Functions
2. DAO Recordsets
3. Arrays and Collections
- Arrays
- Variant Arrayss
- 1D and 2D Arrays
- Typed Arrays
- Functions and Arrays
- Collections
4. SQL and Transactions
- SQL to Select Data
- SQL to Summarize Data
- SQL to Modify Data
- SQL to Remove Duplicates
- Transactions
Part 3
1. Navigation in a Daisy DB
- Queuing
- Cascading
- Switchboard
2. Dynamic Requests
- Binding
- Synchronizing
- Building on the Fly
3. Ins and Outs
- Exporting into Excel
- Importing from Excel
- Email and PDF Files
4. Add-Ins
- Building Add-Ins
- Using Add-Ins
5. Custom Classes
- Building Classes
- Using Classes
- Class Collections
6. Protection + Security