Course Details close

Course Details

Price:
(inc GST)
$ 1485
Application:Access
Level:VBA Basic
Version:All-Versions
Duration:3 days
Location:
Level 2
80 Mount St
North Sydney
NSW 2060
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 completes the necessary learning skills required to build any serious database. This 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.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 Training Course 2010 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.

Course Dates

Course Date Price Add Course Qty Status

There are currently no public dates scheduled for this course.

If you have 3 or more people interested in this course, call us today to discuss group training - 1300 937 782.

Course Outline

VBA Basics

  • The Programming Environment
  • Object Models
  • Navigate With Forms
  • StartUp Forms
  • VBA Editor Window
  • Project Explorer
  • Properties Window
  • Modules Basics
  • View Forms Code
  • Standard Code Modules
  • Naming Conventions

VBA Subroutines

  • Access Modules Explained
  • Procedures Explained
  • Module Breakdown
  • Subroutines
  • Functions
  • Call Procedures
  • Pass Parameters
  • Return Values
  • Scope Procedures

Variables

  • Variables Explained
  • Data Types Explained
  • Create/Use Variables
  • Implicit/Explicit Declarations
  • Numbers In VBA
  • Overflows
  • Decimals In VBA
  • Dates In VBA
  • Default Values
  • Scope Of Variables Explained
  • Procedure Level Scoping
  • Module Level Scoping
  • Pass Variables By Reference
  • Pass Variables By Value

Making Decisions

  • If Statement Explained
  • Single-Line If
  • Block If
  • Multiple Ifs
  • If Statements Assignment
  • If For Multiple Text Conditions
  • Select Case Statement
  • Simple Select Case Statement
  • Value Ranges In Select Case Statements
  • Select Case Statements With OR

User Interactions

  • Input Boxes Explained
  • InputBox Function
  • InputBox Function Arguments
  • Message Boxes Explained
  • Simple Message Box
  • Longer Messages
  • Break Message Lines
  • Buttons And Icons
  • Message Box Function
  • Different Buttons

The DoCmd Object

  • DoCmd Explained
  • Navigate With DoCmd
  • Move Through Records
  • Filter Records With DoCmd
  • Open/Close Form With DoCmd
  • Open Report With DoCmd
  • Create Variable Reports

Looping in VBA

  • Loops Explained
  • For Loops
  • While Loops
  • Counters
  • Until Loops
  • For…Each Loops
  • Exiting From Loops
  • For...Next Loops
  • Creating Loops Assignment

Debugging VBA

  • Debugging Explained
  • Set Breakpoints
  • Additional Breakpoints
  • Step Through Procedure
  • Call Stack
  • Locals And Immediate Windows
  • Add A Watch

Form Validation

  • Data Validation Summary
  • Validate Between Fields
  • Highlight Current Field
  • Highlight ALL Required Fields
  • Add to Combo Boxes using NotInList Event
  • Value Lists
  • Single Selection in ComboBox
  • Multiple Columns in ComboBox
  • Request a Change via Email

Control User Access Level

  • Retrieve User Roles
  • Allow… Properties
  • Disable/Enable Controls and Menu Options
  • OpenArgs
  • Tag Property
  • Form Timer Event

References

  • Set References
  • Available References
  • Other Libraries
  • Late/Early Binding
  • Binding with Outlook

External Reference - File Dialogs

  • FileDialog Object Members
  • Create File Dialog
  • Select Single File Only
  • File Type Filter
  • Select Multiple Files
  • Generic File Dialog module
  • Define File Types
  • Store returned file paths
  • Store Multiple Values with Array
  • Extend Projects

Files and Folders

  • MS Scripting Runtime Library
  • FileSystem Object
  • Folders
  • Create/Delete Folders
  • Check for Folder Contents
  • Consolidate Create/Delete/Review Routines
  • Copy/Move Folder
  • Next Steps
  • Files
  • Add Files
  • Write To Text File
  • Copy/Move/Delete Files

Audit Logging Routines

  • Capture User Login/Logout Details
  • User Login/LogOut Routines
  • Log Form/Report Interaction
  • Log Opening/Closing Time
  • Retain Full Data History
  • Additional Aspects

Error Handling

  • VBA Error Handling
  • Error Handling Logic
  • Standard Error Handling Routine
  • Logging Errors
  • Extend Error Handling
  • Keep User Informed of System State

Code Comments & Templates

  • Add Detailed Comments
  • Create Database Templates
  • Import Objects
  • Export Objects as Text Files

Access Developer Tools

  • Create Database Template

Access Recordsets

  • ADO
  • Connection Object
  • Command Object
  • RecordSet Object
  • Remove References to SET Variables
  • DAO
  • Create DAO Recordset
  • Using DAO Recordsets
  • Bound Forms & SubForms
  • Convert Bound To UnBound
  • Forms RecordSet
  • Navigation Elements
  • Add/Edit New Records
  • Delete Records
  • Complete Unbound Form
  • Add Error Trapping
  • Code Duplication

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
    Excellent trainer very generous with his time and patience.
    - Wayne
  • Access VBA Basic training course
    I learnt a lot and it was enjoyable
    - Cindy
  • 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
    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
    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
    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
    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
    Great course enjoyed Craig's Facilitating.
    - Sascha
  • Access VBA Basic training course
    I learnt a lot and it was enjoyable
    - Cindy

Need Assistance

  • Send Email
Raising the Bar
Warning Icon Information Icon

OK
1300 937 782 Contact us