Microsoft Access VBA Advanced Training Course Outline

Audience: If you already know how to create subroutines in VBA, declare variables and can write loops and conditions then this Access VBA advanced course is the course for you!

We are happy to arrange for a trainer to contact you to help tailor you course.

Course Duration: 1 day.

Course Availability: Monday – Saturday

Course Types: Group bookings, public courses, 1-2-1 sessions, bespoke tailored courses and office migrations.

Course Location: This Access VBA advanced training course can be delivered either at our London training venue or at your offices. 

Tailored Course Content: Course content can be customised to meet your specific requirements, with scheduled dates to suit you.

At Course Completion

After completing this course, students will be able to:

  • Recap your understanding of VBA theory
  • Link to other applications
  • Use the FileSystemObject
  • Code file dialogs
  • Work with text files
  • Create Class modules
  • Link to data
  • Declare and populate arrays
  • Pass argument values effectively
  • Understand advanced programming ideas

Course Outline

Module 1: Revision of VBA

  • Objects and collections
  • Methods and properties
  • Using object variables
  • Looping over collections

Module 2: Links to other applications

  • Referencing other applications
  • Instantiating objects 
  • Writing inter-application code

Module 3: Using FileSystemObject

  • Referencing FileSystemObjects 
  • Working with files and folders

Module 4: File Dialogs

  • Using File Dialogs
  • Allowing multiple selection

Module 5: Working with text files

  • Avoiding using INPUT/OUTPUT
  • Reading and writing text files

Module 6: Class modules

  • What is a class?
  • Designing classes
  • Creating properties and methods 
  • Consuming classes
  • Untyped collections 
  • Creating typed collections
  • Creating event sinks

Module 7: Linking to data

  • ADO or Access Database Engine
  • Referencing the right library
  • Opening and using recordsets

Module 8: Arrays

  • Creating and populating arrays
  • Dynamic arrays 
  • The Preserve keyword

Module 9: Passing arguments

  • ByRef and ByVal 
  • Using optional arguments
  • Using ParamArray

Module 10: Advanced programming ideas

  • Using functions in code 
  • Recursive programming 
  • Enumerations
, Microsoft Access VBA Advanced Training Course Outline
, Microsoft Access VBA Advanced Training Course Outline