Access VBA

Access VBA (Visual Basic for Applications) is an effective way to extend the capabilities of Microsoft Access. Compared with Excel VBA, Access VBA is not the most straightforward VBA to learn. A great deal of Access VBA code is Access specific ie not generic with regard to the other VBAs (Word and Excel). It is also not always the best behaved VBA, and can be a little tricky at times. This is where we come in! Some students may have some knowledge of basic programming techniques eg For Loops etc but if not, this is covered and in any case revised. The level to start with is very basic but eventually even ADO is covered as well as an introduction to classes and APIs.

Once again the philosophy is to provide for time between classes for revision. It is not our policy to teach continuously and risk students becoming fazed. Some exercises are set between sessions for revision. Indeed the revision (3 - 4 hrs per class) is probably the most important aspect of the training!

A colourful and hopefully much simlified manual is provided. A text is also recommended to accompany the manual - a chapter by chapter correspondence.

Our Access VBA courses run as evening or daytime courses from Bloomsbury Square.

What does the Access VBA course cover?

12 x 2.5 hour lessons = 30 hours total. Wednesday Evenings 6.30-9pm. Day Times to be arranged.

Topics covered on this course are:

• Make An Access Macro
  
• To Edit the Code
  
• Code Modules
  
• To Convert an Access Macro to Code
  
• To Write Access VBA Code directly
  
• The code behind Forms.
  
• Form events: Current, GotFocus, Enter, Before Insert, Filter etc.
  
• The Object Browser
  
• Error handling
  
• Combo boxes
  
• Option groups
  
• Keyboard events: KeyUp etc.
  
• Using a Form's RecordsetClone.
  
• Using DoCmd to open Forms and Reports.
  
• The Nz function.
  
• Making and preventing data changes with a Form.
  
• To attach Code To A Menu Bar
  
• One to Many Forms.
  
• The difference between Refresh and Requery.
  
• Menus and Toolbars
  
• The Object Browser
  
• Objects and Collections
  
• Data Access Objects (DAO)
  
• Transactions
  
• To Make a Table from Code using DAO
  
• To Create a Query From Code using DAO
  
• Customizing Reports with VBA
  
• Report events.
  
• Introduction to SQL
  
• Introduction to XML.
  
• API (Application Programming Interface)
  
• Automation: To Control Access from Excel
  
• Introduction to ActiveX Data Objects (ADO)

Individual Courses:

20 hrs: These can be aranged to suit but it is not recommended that these are continous. The course content is quite considerable so it is essential that a student is able to allocate a few hours beween sessions to practising and doing set exercises.

8 sessions of 2 1/2 hrs each or 10 sessions of 2 hrs each for example.