Microsoft Visual Basic for Access 2010

  • Microsoft Visual Basic for Access 2010, Singapore elarning online course
  • Microsoft Visual Basic for Access 2010, Singapore elarning online course
  • Microsoft Visual Basic for Access 2010, Singapore elarning online course
  • Microsoft Visual Basic for Access 2010, Singapore elarning online course
  • Microsoft Visual Basic for Access 2010, Singapore elarning online course
  • Microsoft Visual Basic for Access 2010, Singapore elarning online course

Course Description

Microsoft Access allows a user to create many different items: tables, forms, reports, macros, and queries. However, the greatest power lies in Modules. Modules contain Visual Basic for Applications (VBA) code that runs in the background, performing more complex operations than any of the other items can perform. This VTC course will discuss how to do many different processes in VBA Modules, including creating customized data items and classes, as well as referencing data that exists in a separate database.

Find out more about Microsoft's productivity tools!

- Learn and understand the purpose of Microsoft's tools
- Know more about the functionality and features of each application
- Learn about functions that you never knew existed in Microsoft's tools
- Be fluent and an efficient user in Microsoft tools by the end of this course

Course Objectives

1. Know and understand the basics of Microsoft Visual
2. Know how to navigate the interface and tools pane 
3. Knows what are Objects, Classes, Databases and Recordsets
4. Understand the basic formulas available and be able to apply them into projects 
5. Know what is Event and Event Procedures
6. Understand about Form and Record Navigation 
7. Know about Collections and User-Defined Data Types
8. Know about VBA and Form Objects 
9. Understand about Embedded SQL 

Related Courses

  • An Essential Online Course: Advanced Microsoft Excel Course (PC: 2013, 2007/2010, 2016)

    An Essential Online Course: Advanced Microsoft Excel Course (PC: 2013, 2007/2010, 2016)

    SGD $79.60

    Course Description

    Microsoft Excel is a spreadsheet developed by Microsoft for Windows, Mac OS X, Android and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993, and it has replaced Lotus 1-2-3 as the industry standard for spreadsheets. Excel forms part of Microsoft Office. Demystify some of the most complex business relevant areas of Microsoft Excel. With 160 videos and loads of practice exercises you will be able to use the most hard to grasp Excel functions in no time.  Grasp this chance to immerse in the knowledge of Advanced Microsoft Excel  - Further your knowledge in Microsoft Excel  - Learn about advanced steps and functions that you have yet to find out - Gain an advantage when presenting your next spreadsheet  - Be equipped with an extra set of skills in Microsoft Excel  Training for Advanced Excel (PC version:2013, 2007/2010, 2016) This course is Skillsfuture Credit Eligible.


  • Joomla! 2.5: An Essential Management System

    Joomla! 2.5: An Essential Management System

    SGD $45.00

    Course Description

    Joomla is a popular and highly functional content management system. Joomla is a mobile ready, responsive system that will adapt to user platforms and is extremely user friendly for both site users and site managers. In this VTC course, author Melanie Hedgespeth will show you how to install Joomla and work with the site from an administrative standpoint. From the administration side of Joomla you will learn how to handle users and permissions, increase Joomla functionality with extensions, change templates and most importantly how to keep your site secure and backed up.Keep your back covered with Joomla!- Learn how you can keep your page secure and backed up with Joomla- Know how Joomla can play a constructive part in maintaining your page - Learn how Joomla can prevent malicious acts on your page ​- Understand how Joomla's key functions can fend off attacks on your pagesThis course is SkillsFuture Credit Eligible.


  • EXIN Cloud Computing

    EXIN Cloud Computing

    SGD $299.00

    Course Description

    Exin's Cloud Computing Foundation is not only a technical cloud course, but focuses on the business and management side of cloud computing as well. This course also examines the auditing and service response within cloud computing, as well the delegation of IT responsibilities within an eviroment focused on cloud technology. This course covers how cloud technology deals with a variety of different areas, including: Hardware, Software, Processes, OS and Application Licenses, People, Power and Backups. Understand how Cloud Computing works! - Know what exactly is Cloud Computing - Understand the concept of Cloud Computing  - Understand how Cloud is applied in today's IT  - Catch onto the advantages of Cloud 




Preview Available


What the Course Is About

Why Code VBA in Access


Preview Available


What an Object Is

Object Properties

Object Methods

Form Methods

Referencing Data in Code

What IS Is

Application Object

Window Object

Events and Event Procedures


Events and Event Procedures Introduction

Reading Data

Form Events

Object Events

Events Causing Events

Sample Event Procedure

Form and Record Navigation


Record Navigation Buttons

DoCmd Object

Record Navigation Events

Adding New Records

Form Operation Events

Report Operation Events

Sample Navigation

Collections and User-Defined Data Types


Creating Composite Data Types

Declaring Variables of Composite Types

Accessing Data in Composite Types

Nested Types

Dynamic Arrays


Creating a Collection

Searching a Collection

Sample Collection

VBA and Form Objects



Option Buttons

VBA Code for Option Groups

List Box Single Selection

List Box Multiple Selection

Filling List Box

Sample Data Fill

Embedded SQL


What Embedded SQL Is

SELECT Statement

WHERE Clause

Computed Fields

SQL Summation Functions

SQL Row Limitation Functions

Sample Query

Sorting Results

Grouping Results

Sample Gathering


Sample Join

Action Queries



What a Recordset Is

Creating a Recordset

Opening Recordsets

Recordset Navigation

Finding Records

Reading and Updating Records

Adding and Deleting Records

Snapshot Recordsets

Sample Recordset

Sample Recordset Use

Sample Recordset Find



What a Class Is

Defining a Class and Data

Class Properties

Class Methods

Initialize Method

Sample Class Design

Sample Class Code



Using Data from a Remote Database

Database Object

Connection Object

Using Remote Databases

Referencing Remote Databases



Course Wrap Up

Planning for Events

Navigation Forms

Resource Files



About the Author

SGD $40.00
(Price excludes GST)
Convince your boss email
This site is best viewed using the latest versions of Google Chrome, Apple Safari, Mozilla FireFox, Microsoft Internet Explorer 11 and Edge which supports HTML5/Webkit technologies.