Microsoft Access VBA Programming (Level 4) 2003 2007 2010 2013 2016 & 365

Training

In Newcastle Upon Tyne

£ 495 VAT exempt

Description

  • Type

    Training

  • Level

    Advanced

  • Location

    Newcastle upon tyne

  • Duration

    2 Days

  • Start date

    Different dates available

Microsoft Access VBA Programming (Level 4) is an advanced training course. Participants will learn how to add Visual Basic coding to add extra functionality to a Microsoft Access database.

Important information

Documents

  • Course content

Facilities

Location

Start date

Newcastle Upon Tyne (Tyne and Wear)
See map
The Quadrus Centre, Woodstock Way, Boldon, NE35 9PF

Start date

Different dates availableEnrolment now open

About this course

This course is intended for participants who have a thorough knowledge of Microsoft Access.

Certificate of participation can be obtained if required.

On receiving your request we will contact you to explain course content, including course dates and payment options.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Microsoft Access
  • VBA Programming in Access
  • Programming
  • Microsoft Access VBA Modules
  • Visual Basic Applications
  • Access Forms
  • MS Access Message Box Function
  • Looping Commands
  • Access Programming
  • Programming Techniques

Teachers and trainers (1)

Chris Edmondson

Chris Edmondson

IT Trainer

Course programme

Course review:

1 VBA Development Environment

  • When to use VBA
  • Options
  • Navigation

2 Creating Modules, Functions and Sub-routines

  • New Modules
  • Creating a Function or Procedure
  • Passing Arguments and Returning values

3 Using Variables and Expressions

  • Naming Conventions
  • Declarations
  • Assigning Values

4 Declaring Variables and Data Types

  • Dimension Statement
  • Data Types

5 Branching and Looping commands

  • Indenting Code
  • If … Then
  • Select Case
  • For … Next
  • Do … Loop

6 Arguments

  • Named and Optional

7 “Bugs"

  • Types of Error
  • Syntax or Logical
  • Debug Window
  • Breakpoints
  • Using Message Boxes

8 Example Functions

  • Text Functions
  • Date Examples

9 Event Procedures on Forms

  • Using the Builder
  • Form Events and Properties
  • Form Modules
  • Validation Procedures

10 Writing Event Procedures

  • Bespoke Functions
  • Changing Controls

11 Trapping Errors

  • On Error
  • Error Codes

12 Manipulating Record Sets

  • Opening Databases
  • Recordset Objects
  • Manipulating Data
  • Finding Data
  • Modifying Queries

Microsoft Access VBA Programming (Level 4) 2003 2007 2010 2013 2016 & 365

£ 495 VAT exempt