Project Description


Welkin Course Code: PA10

Course Features

With Access VBA programming, you can automate processes and add functionality to your Acccess database. In the course you will learn Access VBA programming techniques that enable you to go beyond capabilities offered by basic Access usage. Course topics include:

  • Understanding programming and modules in Access
  • Working with procedures and functions
  • Understanding object hierarchy in Access
  • Using variables, arrays and constants
  • Debugging code
By the end of the course you should be able to use Access VBA programming to automate certain processess and add functionality to your Access database.
  • Qualified and experienced instructors
  • Easy-to-follow, step-by-step hands-on approach
  • Best practices explained and demonstrated

Learn from the Experts

Get Your Skills Certified

Certify your Access skills with Microsoft Office Specialist certification. The certification is not a requirement for course completion but we highly recommend you to get your skills professionally recognized.
Remark: The course fee does not include the certification exam.

Further Study

After completing this course you may further develop your knowledge and skills in Microsoft Access with the course Access and Excel Integration with VBA.

Course Fee


Course Duration

18 Hours

Course Prerequisites

Course participants should have a basic knowledge of Microsoft Access.

Title of Award

Upon successful completion of the course, students will receive a Certificate of Achievement.

Schedule & Online Enrolment
Sign up for your course by clicking the Enrol button and proceed to Checkout to finish course registration.

Microsoft Access 2010 Programming
Course No. 課程編號Info. 語言/系統/地點Start 開課日End 完課日Day(s) 上課日Time 上課時段Duration 課程長度Enrol 報名

The course teaches programming concepts and how to add functionality to a Microsoft Access database by using Microsoft Visual Basic for Applications (VBA).

  1. Getting Started
    • Introduction to Programming in Access
    • Why Program in Access?
    • Creating a Macro
    • Understanding Modules
    • Creating a Standard Module
    • Understanding the Development Environment
    • Using the Project Explorer
    • Using the Properties Window
    • Using the Code Window
  2. Working with Procedures and Functions
    • Understanding Procedures
    • Creating a Sub Procedure
    • Creating a Function Procedure
    • Calling Procedures and Functions
    • Using the Immediate Window
    • Working with Code
  3. Understanding Objects, Properties, methods and Events
    • Understanding Objects and Collections
    • Understanding Properties
    • Understanding Methods
    • Understanding Events
  4. Understanding the Access Object Hierarchy
    • Understanding Access Objects
    • Using the Object Browser
    • Controlling the Application Object
    • Understanding the Forms Collection and Form Object
    • Understanding the Controls Collection and Control Object
    • Using the With Statement
    • Understanding the Reports Collection and Report Object
    • Understanding the DoCmd Object
    • Using the Screen Object
  1. Using Variables, Arrays, and Constants
    • Declaring Variables
    • Declaring Arrays
    • Declaring Constants
    • Declaring Object Variables
  2. Using Functions, Message Boxes, and Input Boxes
    • Using Intrinsic Functions
    • Using Message Boxes
    • Using Input Boxes
  3. Controlling Program Execution
    • Using Control Structures
    • Working with Conditional Expressions
    • Using the If…Then…End If Structure
    • Using the If…Then…Else…End If Structure
    • Using the Select Case…End Select Structure
    • Using Do…Loop Structure
    • Using the For…Next Structure
  4. Debugging Code
    • Understanding Errors
    • Using Debugging Tools
    • Stepping Through Code and Setting Break Points
    • Understanding Error Events
    • Understanding the Err Object
    • Using the On Error Statement
    • Writing an Error Handling Routine
    • Compiling All Procedures
  1. Proceed with on-line registration or send the completed enrolment form (download) to us together with a cheque (made payable to Welkin Compuer Training) for the program fee.
  2. CEF applicants have to complete the CEF Application Form (download) and send it to us for certification. They will then send the form to the Office of the Continuing Education Fund, Room 916, 9/F, Kwai Hing Government Offices, 166-174 Hing Fong Road, Kwai Chung, New Territories, together with a photocopy of their HKID Card before course commencement.

You may also be interested in