Byron Employment

Byron Employment. Over 145,805 Jobs Australia Wide.

Delivery Method

  • Classroom
  • Price: $1155.00

Course Overview

This Access VBA (Visual Basic Programming) course is designed for experienced users of Access who wish to understand the VBA programming environment. At the conclusion of this course, participants will be able to create automated forms and reports and use VBA to manipulate the Access data.

Delivery

Classroom

Duration

3 non-consecutive days.  Multiple-day course sessions are conducted 8-days apart to enable participants’ greater opportunity to absorb and practice learned topics, and cement transfer of skills to their everyday job roles.  Our experience is that this course structure assists with the most effective learning and skills retention.

Locations

  • Public Schedule - Brisbane
  • Group Bookings - All States and Territories across Australia

Prerequisites

Participants must be competent users of the Windows environment, have completed Access Advanced level or have skills equivalent to those covered in:

  • Access 2003 - Introduction (Creating Databases)
  • Access 2003 - Intermediate
  • Access 2003 - Advanced

Course Outline

Writing Procedures

  • Naming a Procedure
  • Naming Rules
  • Event Procedures
  • Guidelines For Entering Code
  • Reviewing the Code

Objects, Properties & Methods

  • Objects, Properties and Methods
  • Collections and Objects
  • Exclamation Marks, Dots & Brackets
  • Properties
  • Methods

Data Types, Variables & Operators

  • Data Types and their uses
  • Working with Variables
  • Working with Constants
  • Operators and expressions
  • Message Boxes
  • Button Arguments and Values
  • Changing Format of Dates
  • Getting User Input
  • Joining Text and Numbers
  • Performing Calculations
  • Working With Large Messages
  • Converting Data types
  • Scope and Lifetime of a Variable
  • Procedure, Module, Public level Variables

Decision Structures in VBA

  • If then
  • If then Else
  • Select Case structure
  • Using Vb constants

Working with Loops

  • Do Until ...loop
  • Do While ...loop
  • For ...Next statement
  • For Each statement

Working with Objects

  • What is an object in VBA
  • Properties of objects
  • Objects of containers of other objects
  • AccessObject Object
  • Using an Object Variable
  • Checking for Selected Items
  • Dynamic Procedures
  • Properties of Objects
  • Storing the Name of An Object
  • Object Variable –v- Variable
  • Special Objects
  • The Me Property
  • Application Objects

Navigation

  • Searching for a Record
  • SetFocus Method
  • Going Back
  • Changing the Record Order
  • SQL Statements
  • Reading & Writing SQL Statements

Data Access Objects

  • Understanding DAO and ADO
  • ADO Object Model
  • Working with RecordSets
  • Creating a RecordSet
  • Close the RecordSet
  • Finding Specific Records
  • RecordSet Boundaries
  • Moving through a RecordSet
  • Filtering a RecordSet
  • Editing Data in a RecordSet
  • Adding a New Record
  • Deleting Records

Lunch

All CTS Training courses provide lunch for publicly scheduled classroom courses

CLICK HERE TO BOOK THIS COURSE NOW!

WANT MORE INFORMATION?
CALL NOW ON (07) 3210 0002
CLICK ON THIS LINK TO ENQUIRE!

CLICK HERE TO
BOOK THIS COURSE NOW!
WANT MORE INFO?
CALL (07) 3210 0002 OR
CLICK HERE TO ENQUIRE

Search Courses

Quick Job Search