UEN No.: 198802365N

Visual Basic Application for Access

COURSE synopsis

Course Details

Course Duration

15 HRS

Course Reference Number

Funding Validity Period

Mode of Training

Classroom

To make use of Visual Basic functions to automate and customise processes in Access using coding.

Who Should Attend

All who would like to develop their skills and knowledge of VBA programming in Access application development to automate task for increase productivity.

Pre-Requisite

No previous programming experience is required. Participants should be currently working with an Access database application that they have built themselves. They should also understand table, query, form and report.

Course Outline

Part 1: Introduction To VBA
  • Macros in Access
  • Creating a macro
  • Running a Macro
  • Assigning a macro to form and switchboard
  • Visual Basic Editor Environment
  • The VBE Window
  • Using the Project Explorer
  • Understanding the Properties Window
  • Using the Code Window
  • Creating a new module
  • Entering VBA codes
  • Customizing VBE environment
Part 2: Beginning With VBA
  • Learning about Objects & Property
  • Understanding the Access Object Model
  • Understanding collections
  • Using the Object Browser
  • Importing and export objects
  • Objects referral
  • Variables, Data Type & Constants
  • Commenting for programming
  • Declaring variables
  • Scoping variables
  • Defining data type
  • Working with Date & String type
  • Using assignment, logical and other operators
  • Arrays
  • Understanding Events
  • Event sequences for various database objects
  • Programming Events & using Code Builder
  • Using MsgBox function for response
  • Form & report events
  • Mouse clicks & focus events
Part 3: VBA Core
  • Procedures, Functions and Constructs
  • Creating procedures by entering codes
  • Scoping a procedure
  • Various methods of invoking a procedure
  • Passing arguments to procedures
  • Inserting procedures
  • Return Type
  • ing built-in functions
  • Using the MsgBox function for data return
  • Using the InputBox function for data request
  • Programming Constructs
  • GoTo
  • If … Then … Else
  • Select Case
  • For … Next loops
  • Do … While loops
  • Do … Until loops
  • While … Wend loops
  • With … End
  • For Each … Next
  • Incorporating custom functions
  • Passing arguments to procedures
  • Error Handling
  • Trapping Error
  • Using Break Mode
  • Setting Breakpoints
  • The Immediate and Watch panes
  • Using Watch variables
  • Using Step commands
Part 4: VBA For Databases
  • VBA for Database Design
  • Understanding Relational Databases
  • Table Design using VBA
  • Configuring Relationships
  • Form & Report design using VBA
  • Incorporating command, navigation & other Controls
  • Setting properties for Form & Report
  • Creating Dialog Boxes
  • Using DoCmd Object
  • Creating a Workspace using Microsoft Jet Engine
  • Using Data Access Object
  • Retrieving & editing recordset
  • Querying data
  • Using VBA objects to read, edit and change data in database
Course Outline

Download the PDF below for a summary of the course outline.

COURSE FEES

Company Sponsored / Self Sponsored

Full Fee GST Nett Fee Payable (incl. GST)
$600 $48 $648

REGISTER TODAY

Select a date below

There is no course available now

Looking at in-house training or have an enquiry? Contact us!

Related Courses

No related courses

GET IN TOUCH WITH US

Have an enquiry? Feel free to connect via any of the channels below.

enquiry form

Leave a message

WhatSAPP

Chat on WhatsApp at
+65 8767 0614

Training hotline

Give us a call at
+65 6737 5761

SHARE THIS COURSE