Access Developer Level 6

This class continues our look at programming in Visual Basic for Applications in Microsoft Access (VBA, or Access VB). We will begin by learning how to convert the macros we built in the Advanced classes into VBA code. We will learn some additional VBA commands, and some new programming techniques.

Next we'll build an Enhanced Timer Form. We briefly learned how to use the Timer event in the Expert classes to download updated weather information from a web site. In today's class we'll expand on that Timer to learn how to create a clock that ticks every second, and launch events in VBA at specified intervals, such as "run this report every 60 minutes," or "send the sales reps an updated sales report every day."

We covered Cascading Combo Boxes briefly in some of our free Tips and Tricks lessons and seminars, but we haven't spent much time with them in an actual class. So in today's lesson we will see how to use them to pick a Product Category, and then see a second combo box that shows just the products from that category. This is handy if you have thousands of products to choose from. You can also use this technique to pick a state, for example, and see just cities from that state. The options are endless.

Finally, we will go over a fan-favorite: how to backup your database. I'm going to show you two different methods. The first is to backup just specific objects from your database - your customer and order tables, for example. The second method will show you how to backup the entire Access database file from within Access itself.

This is the 6th class in the Access Developer series. If you're serious about building quality databases with Access, and you want to learn how to automate your database with VBA Programming then don't miss out on this course. Of course, if you have any questions about whether or not this class is for you, please contact me.
 

Complete Outline - Access Developer Level 6