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