Microsoft Access VBA Programming

Designed for advanced users to program features and functions that improve and manage the usability and accessibility of large quantities of data. Our VBA Programming in Microsoft Access training course will give you the skills to add functionality to your database.

On this course you will be able to use visual basic coding to add functionality to a database, you will be able to execute a program and deal with any bugs or errors in your code with minimal downtime.

The course will give you hands on experience via structured exercises during the session and will give you the opportunity to practice the skills you have learned.
To get the most out of this course some experience of using and creating a database is recommended (including the topics covered in our other Microsoft Access courses) and ideally you should be comfortable with the Microsoft Windows environment.

Course Duration

2 Days

Course Content

Download Course Content PDF

  • Introduction
    • Some Definitions
    • The Visual Basic Editor
    • VBA Editor Options
  • Creating Modules
    • Creating a Standard Module
    • Creating a Function or Procedure
    • Programming Techniques
  • Using Variables and Expressions
    • Naming Conventions
    • Declaring Variables
    • Data Types
    • Assigning Values
  • Some useful Built-in Functions
    • Text Functions
    • Date Functions
    • Numeric Functions
  • Branching and Looping commands
    • If … Then
    • Select Case
    • For … Next
    • Do … Loop
  • Using the MsgBox Function
    • Giving the User some Information
    • Storing the User Response
    • Responding to the User Response
  • Handling Bugs in Your Code
    • Language Errors
    • Run-time Errors
    • Dealing with Logic Errors
    • Debug Window
    • Breakpoints
    • Tips for Reducing Bugs
  • Working with Forms
    • Form Properties
    • The DoCmd Statement
    • Validating Form Entries
    • Using Code to Change Form Properties
  • Working with Tables
    • Using the Correct Library References
    • Databases and Recordsets
    • Checking for Duplicate Entries
  • Working with Queries
    • Storing the Query Definition as SQL
    • Altering the Definition
    • Generating the new SQL Statement
  • Dealing with Errors
    • The On Error Statement
    • Interpreting Error Codes

Download Full Course Schedule PDF

Ask a question

 

Please contact us to make a booking or book now on-line.

All courses are available for both scheduled (open) and dedicated (bespoke) delivery. Please contact us for details and pricing.

If you can’t see the course you are looking for – contact info@base2.co.uk