VBA for ACCESS 2007 (Intelligent Programming with VBA Access)


This course is intended for people who wish to improve their knowledge and skills in the use of Visual Basic for Applications to program applications in Microsoft Access 2007.

Microsoft Access 2007 Level 1 is designed for people who need to know how to create effective databases and to manipulate data to provide viable information.


At the completion of this course, participants will be able to:

  • be familiar with the basics of developing applications in Access 2007
  • create and convert macros into VBA
  • make Access start up with the form you select
  • create subroutines
  • understand how to use variables to generate an output
  • understand and create input boxes and message boxes
  • create and use decision-making programs
  • create and use programming loops
  • understand and use the DoCmd object
  • recognise and understand many ADO techniques
  • use ADO to work with forms and recordsets
  • apply a range of debugging tools to your application
  • replace obscure error messages with meaningful ones

User Reviews

Not yet rated. You will need to follow this course before you can write a review.

Course Info

Next Step

Enquire Now
Tell a Friend
Email Course Outline

Course files