Course Icon VBA Training

VBA Access-Intro

0800 1337 401

Course Objectives

This course aims to give users an introduction to Visual Basic Programming within the Access application. By the end of the course, users will be able to create and edit their own automated procedures. They will have an enhanced understanding of Objects, Variables, Control Of Flow structures, producing User Forms and creating the code for calendar controls.

In addition, while creating and executing the code, the course introduces you to debugging code techniques and how to handle errors to minimise time spent trying to identify errors.

Who Should Attend

This course is designed for people who may need to automate the process to organise, analyse and extract data from data sources and they should have a high proficiency in the use of Access.

Course Syllabus

INTRODUCTION

  • Overview of how to create and run a macro
  • Overview of creating forms and adjusting from control properties
  • Introducing Visual Basic for Applications
  • Opening and Closing the Visual Basic Editor
  • Introducing Objects
  • What is Object Orientated Programming (OOP)
  • What is an Object
  • What is a Collection
  • What are the Access Objects
  • Manipulating Objects and Collections
  • How to work with properties
  • How to work with methods

INTRODUCING VARIABLES

  • Introducing Variables
  • How to declare Variables and explicitly define them and their data types
  • Public v Private Variables
  • Harnessing intrinsic functions
  • Adding message boxes and using input boxes

VISUAL BASIC EDITOR WINDOW

  • Project Explorer pane
  • VBA Projects
  • Modules
  • Procedures
  • Properties pane
  • Procedure window
  • Object selection
  • Procedure selection

CREATING PROCEDURES FROM THE FORM DESIGN WINDOW

  • Introducing Form Events
  • Introduce Control Events
  • Creating Form and From Control Procedures from the From Design View
  • Creating Form and From Control Procedures from the Visual Basic Editor window
  • Creating General Procedures

DEVELOPING WITH PROCEDURES AND FUNCTIONS

  • Creating modules
  • Defining and creating Sub Procedures
  • Calling procedures
  • Introduction to the Immediate window
  • Introduction to the Locals window
  • Making and naming a function procedure
  • Utilising the object browser

PROCEDURE CODE STRUCTURES

  • Defining control-of-flow structures
  • Using Boolean expressions
  • IF…END IF logical procedures
  • Select Case...End Select structure
  • Do...Loop structure
  • For...Next structure
  • For Each...Next structure
  • Using Forms and Controls
  • Understanding controls
  • Setting control properties in the properties window
  • Creating UserForms using the Controls Toolbox
  • UserForm properties, events and methods
  • Using Labels, List Box, Text Box, Combo box, and Checkbox controls

WORKING WITH RECORDSETS

  • Creating a DAO Recordset object
  • Creating a DAO Database object
  • Working with the Recordset object
  • Working with the Database object

INTRODUCTION TO ARRAYS

  • What is an Array
  • Differences between Fixed Array and Dynamic Array
  • Create a 2 dimensional array
  • Resize an Array
  • Writing data to an Array
  • Writing the data from the Array to an Access table

USING CALENDER CONTROLS

  • Adding Calendar controls to the form
  • Produce a procedure to filter results based on dates selected on the Calendar control

HANDLING ERRORS

  • Creating an error handling routine
  • Capturing errors with the on error statement
  • Determining and using the error object
  • Using inline error handling
  • Breaking code
  • Step through code to identify errors in procedures in a General Module
See all of the available Seven Institute Microsoft Courses