Course Code:62.01
Course Subject:Access Visual Basic for Applications
Course Title:Access VBA Introduction
Aims:To provide the student with the knowledge and confidence to write Visual Basic Code in the Access environment.
Introduction:Visual Basic for Applications is based on the very popular Visual Basic programming language. It provides a means of controlling a Access application (Databases, Tables and Queries etc.). The key difference between VBA and Visual Basic is that VBA resides within Microsoft applications like Excel, Word, Visio etc. whereas Visual Basic is a standalone application. VBA code allows the programmer to implement functions and take control of Access objects way beyond conventional database use. This course is intended to provide the student with sufficient knowledge and skills to implement VBA code in Access while also understanding the security and power considerations. The course covers the key areas of writing VBA code with reference to Access and the control of Databases, Tables and Forms. The inherent flexibility of VBA makes it a subject that can be studied for years so one of the main goals of this course is to provide the student with a base upon which to build. On completion the student will be able to write effective, efficient code and take their Access database use to a whole new level..
  

Objectives

The learner will be able to:

Assessment Criteria

The learner has achieved this objective because he/she can:

1. Create Visual Basic Code in the Access VBA environment

  1. Use the Visual Basic Editor

  2. Create Procedures

  3. Understand Variables

2. Understand Objects, Collections, Properties and Methods

  1. Understand Objects and Collections

  2. Understand and use Properties

  3. Understand and use Methods

3. Build Formal Control Structures

  1. Use Comparison Operators

  2. Use If .. Then Decision Structures

  3. Use For Loops

  4. Use Do Loops

  5. Use Select Case Decision Structures

4. Use Visual Basic Functions

  1. Use the InputBox Function

  2. Use the MsgBox Function

  3. Use the DoCmd Method

5. Manage Forms

  1. Manipulate Forms and Controls

  2. Respond to Form Events

6. Use Recordsets

  1. Understand Recordsets

  2. Appreciate the different types of Recordsets

  4. Use Recordsets to manipulate Table contents

  5. Use Form Recordsets

7. Use TableDefs

  1. Understand TableDefs

  2. Create a TableDef (Create a Table automatically through code)