Microsoft Access training - Access Visual Basic (2 days)

This course is for Microsoft Access versions up to 2003 - we also run an equivalent Access 2007 Visual Basic training course.

If you have mastered tables, queries, forms and reports in Access, it is maybe time to learn Access programming. This two-day course shows you how to use Access VBA to automate your databases, making your database development easier - and more fun!

Access Visual Basic training - Course Contents

The contents of our Access Visual Basic course are as follows (any items marked with a * will be covered if time allows). If you aren't sure if this is the right course for you, please call or email us to talk through your options. We want you to be on the right Microsoft Access training course as much as you do!

The VBA code editor
  • Two ways to create modules
  • Using Project Explorer
  • Basic subroutines and comments
Messages and variables
  • The all-powerful DoCmd object
  • Displaying messages
  • Getting input from users
  • Using variables
Creating functions
  • Passing arguments
  • Returning values
Visual Basic explained
  • Objects and collections
  • Methods and properties
  • The Access object model
  • Getting help in VBA
Attaching code to forms
  • Attaching code to buttons
  • Attaching code to events
  • Making code not form-specific
  • Manipulating form/control properties
Looping
  • The four types of loop
  • Looping over all open forms
  • Looping over controls
  • Looping over Access Objects
Modifying queries
  • Basic SQL statements
  • Amending queries' SQL
Recordsets
  • Choosing ADO or DAO
  • Adding data
  • Editing data
  • Deleting data
Debugging and error handling (*)
  • Stepping through macros
  • Setting breakpoints
  • Trapping for errors
Linking to Excel and Word (*)
  • Referencing other applications
  • Manipulating Excel from Access

To help see if this is the right course for you, you can see and download examples of our Access Visual Basic courseware. You can also look at the differences between Microsoft Access Visual Basic versions and see on which Access Visual Basic version we currently train.

Access Visual Basic training - Pre-requisites

Delegates should only attend this course if they have a good working knowledge of Access basics, and if they are proficient computer users. Experience of programming, while useful, is not essential.

Access Visual Basic training - Schedule and Prices

Prices for this Microsoft Access training course are as follows:

There will be a maximum of 6 people on each course, and each person will have their own computer. Please take a moment to see why our Microsoft Access training courses are so different, then use our easy-to-use web-based or telephone booking system to book your course place. Alternatively, call (01457) 858877 or email our training co-ordinator.

Onsite Microsoft Access training

In addition to our standard scheduled Microsoft training courses, we also offer onsite Microsoft Access training. This allows you to create a Microsoft Access training course uniquely tailored to the needs of your staff, covering only those aspects of Microsoft Access which they need to learn.

All content � Wise Owl Business Solutions Ltd 2007.  All rights reserved.  Design by Branches.