Course Details close

Course Details

Price:
(inc GST)
$ 1485
Application:Access
Level:VBA Basic
Version:All-Versions
Duration:3 days
Location:
ITIC Live
Level 3
321 Pitt St
Sydney NSW 2000
Participants:Max 10
Length:9:00 to 16:30
Break Times:
(approx)
10:30 (15mins)
12:30 (1hr)
14:45 (15mins)
Course Dates: View
Course Outline: View

Access VBA Basic Course

   (4.72 out of 5)
236 Access vba basic student evaluations
Location: Level 2
80 Mount St
North Sydney
NSW 2060
Break Times:
(approx)
10:30 (15mins)
12:30 (1hr)
14:45 (15mins)
Duration: 3 days Participants: Max 10
Course Length: 9:00 to 16:30 Price:
(inc GST)
$ 1485
Sale Price:
(inc GST)
$

Quick links

Access VBA Basic Course

Course Overview

The Access VBA Training Course is a comprehensive introduction into VBA. The course is suitable for students who confidently understand and utilise Access to an advanced level on a daily basis and wish to automate and customise complex calculations and processes in their current work flows. Participants must be able to confidently build databases before undertaking this course. At the completion of this course the participant will be able to confidently navigate and utilise the VBA editor to run, edit and debug VBA code.

Participants will also have a solid foundation on the Access Object Model along with their associated properties, methods and events which are the building blocks of the VBA programming language.

Course Prerequisites

Microsoft Access Advanced Course or equivalent

Course Inclusions

FREE Course Re-sit

8 months

When you book a public course at Raisng the Bar we offer you a FREE course re-sit for up to 8 months from the scheduled course date.

FREE Email Support

12 months

Free email support for up to 12 months from the scheduled course date.

Small Class Sizes

10 students

All of our courses are capped at a maximum of 10 students to maximise your learning experience.

Classroom Training

All of our courses are face to face, hands on, classroom based training delievered by .

Course Manual

Every student will receive a printed course manual with step by step instructions to use as a reference guide.

Computer Lab

No need to bring your own laptop. Our training courses are conducted in fully equipped computer labs with free Wi-Fi.

Course Certificate

Every student receives a certificate of completion at the end of course to recognise your new skills.

Virtual Course Dates (via Zoom)

Course Date Price Add Course Qty Status

There are currently no virtual course dates scheduled for this course.

Call us today to discuss - 1300 937 782.

Public Course Dates

Course Date Price Add Course Qty Status
08-Sep-21 (Wed)$1,485.00 0
11-Oct-21 (Mon)$1,485.00 0

Course Outline

Getting Started

  • What is VBA?
  • Open the VBA Editor
  • Create a Module
  • Create a New Subroutine
  • Add Commands
  • Run the Subroutine
  • Save the File

Security

  • Open a File Containing Code
  • Create a Digital Signature
  • Digitally Self-Sign a File
  • Add the Publisher to the Trusted List
  • Install Certificates
  • Remove Trusted Publishers

Using the VBA Editor

  • Run Code in the VBA Window
  • Step Through Code
  • Step Over Code
  • Set a Break Point
  • Comment Code
  • IntelliSense and AutoComplete
  • Getting Help
  • The Project Explorer and Properties Window

Variables

  • What is a Variable?
  • Naming Variables
  • Store a Value in a Variable
  • Why Should I Declare Variables?
  • Procedure-Level Declarations
  • Module-Level Declarations
  • Global-Level Declarations
  • Static Declarations
  • Option Explicit
  • Declaring Data Types
  • Recognise Errors From Declaring Variables
  • Discover the Current Value of a Variable

Interactions With The User

  • Interacting With the User
  • MsgBox as a Method
  • MsgBox as a Function
  • Message Box using Numerical Constants
  • The InputBox Function
  • Long Messages

Making Decisions

  • A Note On Indenting
  • Line If
  • Block If
  • ElseIf and Else
  • Select Case

Looping

  • For/Next Iterations
  • For/Next Stepped Iterations
  • Do/Loop With Initial Test
  • Do/Loop With Final Test

Error Handling

  • Run-time Errors
  • Add a Simple Stop
  • The Err Object
  • Exit Sub
  • Error Handling with Another Sub
  • Resuming

Class and Standard Modules

  • Course Prerequisite
  • Security and Trusted Locations
  • Create a Standard Module
  • Edit a Standard Module
  • Edit a Class Module Locate and Run Code from the Class Module

Access Objects

  • The Object Hierarchy
  • Locate an Object
  • Properties and Methods
  • The Application Object
  • The DoCmd Object
  • The Forms and Controls Objects
  • The Me Object Adding Higher Hierarchical Levels

ADO

  • How Does ADO Work?
  • Setting ADO References
  • Connecting to the Database
  • Populate ADO Recordsets
  • Locate a Record using ADO
  • BOF and EOF
  • Filter and Count the Records
  • Add a Record
  • Modify a Record
  • Delete a Record
  • Close the Connection and Recordset
  • Create Objects Using ADOX
  • Delete Objects Using ADOX

Common VBA Techniques

  • Use ADO To Validate A Password
  • Use ADO To Create a Log
  • Using VBA To Populate Form Controls
  • Display And Hide Controls
  • Cascading Combo Boxes
  • Access Data In Hidden Combo Box Columns
  • Let’s Practice Common VBA Techniques

Other Applications

  • The DoCmd OutputTo Method
  • The DoCmd Transfer Methods
  • Define Another Appplication As An Object
  • Manipulating Outlook
  • Manipulating Excel

Student Comments

  • Access VBA Basic training course
    Awesome delivery, exactly what I wanted to learn and fantastic trainer who explained things well. Thank you :)
    - Kathleen
  • Access VBA Basic training course
    I learnt a lot and it was enjoyable
    - Cindy
  • Access VBA Basic Training Course
    Both Karla and Tom are a credit to rtb - professional and very courteous. Tom has an incredible depth of knowledge that he is able to transfer with ease to learners. Thoroughly enjoyed the course
    - Jodi
  • Access VBA Basic training course
    Excellent trainer very generous with his time and patience.
    - Wayne
  • Access VBA Basic training course
    Awesome delivery, exactly what I wanted to learn and fantastic trainer who explained things well. Thank you :)
    - Kathleen
  • Access VBA Basic training course
    I learnt a lot and it was enjoyable
    - Cindy
  • Access VBA Basic Training Course
    Excellent trainer very generous with his time and patience.
    - Wayne
  • Access VBA Basic training course
    Trainer very helpful and jovial - really wanted to ensure gave us examples relevant to our workplace to help retain our knowledge. But at the same time ensured everything in the book was also covered off.
    - Keryn
  • Access VBA Basic training course
    Awesome delivery, exactly what I wanted to learn and fantastic trainer who explained things well. Thank you :)
    - Kathleen
  • Access VBA Basic Training Course
    Thanks so much for all your help. I really appreciate it. And I would not hesitate recommending Raising the Bar to anyone.
    - Katrina
  • Access VBA Basic training course
    I learnt a lot and it was enjoyable
    - Cindy
  • Access VBA Basic training course
    Great course enjoyed Craig's Facilitating.
    - Sascha

Need Assistance

  • Send Email
Raising the Bar
Warning Icon Information Icon

OK
1300 937 782 Contact us