MICROSOFT ACCESS 2003 VBA PROGRAMMING COURSE This Microsoft training is provided in a three day course for those delegates looking to advance their use Microsoft Access 2003 by attending this Microsoft Access 2003 VBA programming course. In order to be able to attend this course, delegates need to have application development or equivalent experience in Microsoft Access 2003. The course outline of the Microsoft Access 2003 VBA programming course includes: Unit 1: Visual Basic Editor Topic 1: Objects Discussing objects Examining the Properties window Modifying the object properties Writing code to change object properties Using a method Associating code with an event Topic 2: Object Browser Examining the Object Browser window Searching in the Object Browser Topic 3: Collections Understanding collection objects Using the Controls collection Unit 20: Programming basics Topic 1: 0 Data Examining data types and variables Declaring variables explicitly Using operators Using the interaction functions Topic 2: 0 Scope Observing modules and procedures Examining procedure- and module-level scope Understanding public scope Creating a Sub procedure Calling a Sub procedure Creating a Function procedure in a standard module Calling a Function procedure Unit 30: Control structures Topic 1: Decision structures Using the If…Then statement Using the If…Then…Else statement Using the If…Then…ElseIf statement Using the Select Case statement Topic 2: Loop structures Using the For…Next loop Using the For Each…Next loop Using the Do While…Loop Unit 40: ActiveX Data Objects Topic 1: Getting started with ActiveX Data Objects Discussing ADO Discussing ADO collections Topic 2: Working with ActiveX Data Objects Connecting to a database Creating a Recordset object Navigating a Recordset Saving and canceling changes Unit 50: VBA debugging tools Topic 1: Errors in code Discussing types of errors Topic 2: Debugging techniques Discussing debugging tools Setting a breakpoint Adding a watch expression Using Step Into Deleting a watch expression Working with the Immediate window Using the Locals window Topic 3: Handling run-time errors Writing error-handling code Appendix 10: Office integration Topic 1: Automating Office 2003 Topic 2: Working with Word from Access Topic 3: Working with Excel from Access As included in this Microsoft training package is equipment, training material, lunch, and refreshments. Booking Information Courses are offered on the availability of students. If you are interested in one of these courses then please click on the e-mail link: (Please specify the course in your email enquiry) Back to Top