Access Visual Basic for Applications Course
(4.82 out of 5) 48 Student Reviews
About the Course
This 3 day course teaches participants to develop programs in VBA for Microsoft Access. A project is undertaken throughout the course to reinforce the concepts . The aim of the project is to put into practice the skills taught during formal sessions, and to foster good coding practices. Special emphasis will be placed on re-usability of code blocks, creation of efficient coding structures and application of standard and consistent VBA coding syntax.
Who should do this course?
This is an advanced level course designed for people who have a thorough working knowledge of Microsoft Access, but need to learn VBA Programming techniques to improve their skills and productivity.
Prerequisites
This course is designed for participants with little or no knowledge of programming, however a sound working knowledge of Microsoft Access is essential, including formatting, reports, queries and relational databases.
Course Details
$1485 incl GST
- Duration:3 Days
- Max. Class Size:10
- Avg. Class Size:5
-
Study Mode:
Classroom Online Live
- Level:Expert
- Course Times: Classroom: 9.00am to 5.00pm approx(Local Time) Online Live: 9.00am to 5.00pm approx(AEST or AEDT)
- Download Course PDF
Course Dates
Sydney Class Dates
Level 11, 32 Walker Street, North Sydney , NSW 2060
Classes scheduled on demand in Sydney
Please our waitlist and we'll notify you when a new class is scheduled or contact us to discuss your training needs.
Melbourne Class Dates
Level 12, 379 Collins Street, Melbourne , VIC 3000
Classes scheduled on demand in Melbourne
Please our waitlist and we'll notify you when a new class is scheduled or contact us to discuss your training needs.
Brisbane Class Dates
Level 6, 371 Queen Street, Brisbane , QLD 4000
Classes scheduled on demand in Brisbane
Please our waitlist and we'll notify you when a new class is scheduled or contact us to discuss your training needs.
Canberra Class Dates
All courses facilitated in, Online Live format ,
Classes scheduled on demand in Canberra
Please our waitlist and we'll notify you when a new class is scheduled or contact us to discuss your training needs.
Adelaide Class Dates
All courses facilitated in, Online Live format ,
Classes scheduled on demand in Adelaide
Please our waitlist and we'll notify you when a new class is scheduled or contact us to discuss your training needs.
Perth Class Dates
All courses facilitated in, Online Live format ,
Classes scheduled on demand in Perth
Please our waitlist and we'll notify you when a new class is scheduled or contact us to discuss your training needs.
Course Units
⊕ Expand full topic list
Unit 1: VBA Essentials
- Understanding The Programming Environment
- Exploring The Object Model
- Navigating With Forms
- Creating A StartUp Form
- The VBA Editor Window
- Working With The Project Explorer
- Working With The Properties Window
- Understanding Modules
- Viewing The Code Behind Forms
- Standard Code Modules
- Understanding Naming Conventions
⊕ See more
Unit 2: VBA Subroutines
- Understanding Modules In Access
- Understanding Procedures
- Anatomy Of A Module
- Creating A Subroutine
- Creating A Function
- Calling Procedures
- Passing Parameters
- Returning Values
- Scoping Procedures
⊕ See more
Unit 3:Using Variables
- Understanding Variables
- Understanding Data Types
- Creating And Using Variables
- Implicit And Explicit Declarations
- Working With Numbers In VBA
- Dealing With Overflows
- Working With Decimals In VBA
- Working With Dates In VBA
- Default Values
- Understanding The Scope Of Variables
- Procedure Level Scoping
- Module Level Scoping
- Passing Variables By Reference
- Passing Variables By Value
⊕ See more
Unit 4: Making Decisions
- Understanding The If Statement
- Creating A Single-Line If Statement
- Creating A Block If Statement
- Creating Multiple If Statements
- Assignment: Creating If Statements
- Using If For Multiple Text Conditions
- Understanding The Select Case Statement
- A Simple Select Case Statement
- Value Ranges In Select Case Statements
- Using Select Case Statements With OR
⊕ See more
Unit 5: Interacting with users
- Understanding Input Boxes
- Using The InputBox Function
- Using InputBox Function Arguments
- Understanding Message Boxes
- Creating A Simple Message Box
- Creating A Longer Message
- Breaking A Message Line
- Displaying Buttons And Icons
- Using The Message Box Function
- Responding To Different Buttons
⊕ See more
Unit 6:The DoCmd Object
- Understanding DoCmd
- Navigating With DoCmd
- Moving Through Records
- Filtering Records With DoCmd
- Opening And Closing A Form With DoCmd
- Opening A Report With DoCmd
- Creating Variable Reports
⊕ See more
Unit 7: Looping in VBA
- Understanding Loops
- Understanding For Loops
- Creating A While Loop
- Working With Counters
- Creating An Until Loop
- For…Each Loops
- Exiting From Loops
- For...Next Loops
- Assignment: Creating Loops
⊕ See more
Unit 8: Debugging VBA
- Understanding Debugging
- Setting A Breakpoint
- Setting Additional Breakpoints
- Stepping Through A Procedure
- Viewing The Call Stack
- Using Locals And Immediate Windows
- Adding A Watch
⊕ See more
Unit 9 : Form Validation
- Data Validation Overview
- Validating Between Fields
- Highlighting the Current Field
- Highlight ALL Required Fields
- Adding to Combo Boxes using the NotInList Event
- Value Lists
- Table/Query Lists (Single Selection in ComboBox)
- Table/Query Lists (Multiple Columns in ComboBox)
- Requesting a Change (via Email)
⊕ See more
Unit 10: Controlling User Access Level
- Retrieving User Roles
- Using the Allow… Properties
- Disable / Enabling Controls and Menu Options
- Using OpenArgs
- The Tag Property
- The Form Timer Event
⊕ See more
Unit 11: Setting References
- Setting References
- Available References
- Locating Other Libraries
- Late Vs. Early Binding
- Using Outlook – Early Binding
- Using Outlook – Late Binding
⊕ See more
Unit 12: Using an External Reference - File Dialogs
- FileDialog Object Members
- Creating a File Dialog
- Selecting a Single File Only
- Creating a File Type Filter
- Selecting Multiple Files
- Creating a Generic File Dialog module
- Defining the File Types (as optional arguments)
- Storing the returned file path
- Storing Multiple Values – using an Array
- Extending the Project
⊕ See more
Unit 13: Working with Files and Folders
- Features of the Microsoft Scripting Runtime Library
- Using the FileSystemObject
- Working with Folders
- Creating Folders
- Deleting Folders
- Checking for Contents of a Folder
- Consolidating the Create/Delete/Review Routines
- Copy Folder
- Move Folder
- Next Steps
- Working with Files
- Adding Files
- Writing To a Text File
- Copying and Moving Files
- Deleting Files
⊕ See more
Unit 14: Audit Logging Routines
- Capturing User Login/Logout Details
- User Login Routine
- User LogOut Routine
- Logging Form/Report Interaction
- Logging the Opening Time
- Logging the Closing Time
- Retaining Full Data History
- Further Considerations
⊕ See more
Unit 15: Error Handling
- VBA Error Handling
- Error Handling Logic
- Creating a Standard Error Handling Routine
- Logging Errors
- Extending Error Handling
- Keeping the User Informed of the System State
⊕ See more
Unit 16: Code Commenting & Template Creation
- Adding Detailed Comments – A Structured Approach
- Creating a Database Template
- Importing Objects into the Template DB
- Exporting Objects as Text Files
⊕ See more
Unit 17: Using the Access Developer Tools
- Creating a Database Template
⊕ See more
Unit 18: Access Recordsets
- ADO
- The Connection Object
- Command Object
- RecordSet Object
- Removing References to SET Variables
- DAO
- Creating a DAO Recordset
- Working with DAO Recordsets
- Bound Forms & SubForms (Using Queries)
- Change From Bound To UnBound (Using RecordSets)
- Creating The Forms RecordSet
- Completing the Navigational Elements
- Adding New Records
- Editing Records
- Deleting Records
- Completing The Unbound Form
- Adding Error Trapping
- Dealing with Code Duplication
⊕ See more
Related Courses
Course Reviews
Cyrus was fantastic. One of the best courses I have done. I have a lot I can take back to work and apply in my projects. Thank you
Daniel was a patient course instructor who provided many examples and answers to challenging questions.
A good range of course materials has been provided, along with lots of support & guidance on achieving the student's specific goals. Especially good to have a small group.
A great course, very informative and well paced. I am looking forward to putting my new skills to work when I get back to work
Enquire Now
Fill in your details to have a training consultant contact you to discuss your training needs.
Note: Form fields marked with * are required.
