Microsoft Access Programming (2010/2007) 2017-08-04T14:26:26+00:00

Project Description

Loading...
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 Professional Recognition

mos-certificate

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

$3660

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
Enquiry/Booking
COURSE INFODATES(dd/mm)TIMEDURATIONDAY(S)AMOUNT
PA10-42C2C
 Central
 Cantonese / PC
2/11~21/11
1900-220018 hrs/
6 sessions
TUE, THU3,660.00
PA10-13C4K
 Mongkok
 Cantonese / PC
4/12~20/12
1900-220018 hrs/
6 sessions
MON, WED3,660.00
PA10-6A6C
 Central
 Cantonese / PC
6/1~10/2
1000-130018 hrs/
6 sessions
SAT3,660.00
PA10-13C5K
 Mongkok
 Cantonese / PC
5/2~26/2
1900-220018 hrs/
6 sessions
MON, WED3,660.00
PA10-24C6C
 Central
 Cantonese / PC
6/2~22/2
1900-220018 hrs/
6 sessions
TUE, THU3,660.00
PA10-6D10K
 Mongkok
 Cantonese / PC
10/3~24/3
1000-1300
1400-1700
18 hrs/
6 sessions
SAT3,660.00
Microsoft Access 2010/2007 Programming
Complete your Enrol
How to enrol/pay online

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.
  3. Applicants will receive application results from the Office of the CEF within 14 working days.

 

You may also be interested in