"A Training Solution Provider delivering Learning Skills to keep forever"

Call the JCS training team free now 0800 5425 150 Or mail Email | training@jcstraining.com
  • Microsoft/Microsoft Access Level 4 Course Duration: 1 day

Microsoft Access Level 4 Course Duration: 1 Day

Course Overview

During this advanced training day we concentrate on using Visual Basic for Applications (VBA) thus building on the skills learnt in MS Access L3 training. Prerequisites: Candidates should have ideally attended the Microsoft Access L3 training or have equivalent working knowledge.

 

 

Contents:

Converting Macros to VBA

Programming with VBA

  • The VB Editor
  • Adding Comments
  • Procedures and Functions
  • Passing parameters and returning values
  • Understanding objects, properties, and methods
  • Simple Input and Output (using InputBox and MsgBox)
  • Variables: declaration, scope, lifetime
  • Object variables
  • Controlling Programme Execution (If, Select Case, Loops etc)
  • Mathematical and logical operators
  • Using the built-in VB functions
  • Trapping runtime errors
  • Using the Access “DoCmd” Object
  • Working with RecordSets

Debugging your code

  • Setting breakpoints
  • Stepping through code
  • The immediate, autos, and watch windows

Deploying your database

  • Protecting your database design and code
  • The Access Runtime
  • Testing your database in the runtime environment
  • Packaging your database into an installation program