Microsoft Partner
Microsoft Access VBA Advanced

Audience: Audience: If you already know how to create subroutines in VBA, declare variables and can write loops and conditions then this is the course for you to further enhance your skills and knowledge.

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

Course Location: This Access VBA Advanced training course is delivered at our training centre in London situated close to Liverpool Street station, training can also be delivered at your offices. Tailored course content can be customised to meet your specific requirements, with scheduled dates to suit you.


MOS Excel Specialist / Expert Exam Costs ( optional )


All Vouchers now include a Retake Voucher
Option 1 - Voucher & Retake

Option 2 - Voucher, Retake and Gmetrix ( Test Prep )

Option 3 - Exam Pack includes - Voucher, Retake, Gmetrix and Exam study manual

Discount 4 for 3 on MOS Exam Packs


View Scheduled Public Courses



After completing this course, students will be able to:reaining course
  • 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 Content

    print this page
  • 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




Call us now for further information Tel:08001601666