Access VBA

Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Sed molestie, velit ut eleifend sollicitudin, neque orci tempor nulla, id sagittis nisi ante nec arcu.

Course description

Level:   Advanced 
Duration:   2 days 

 Microsoft Access is the desktop database design product from the Microsoft Office professional suite. This course teaches experienced Access users about the greater 

advantages to be gained by combining the builtin features of Access with the programming 

The course is designed to give delegates a thorough overview of programming within the 

Access environment, enabling them to improve the functionality and productivity of their Access 

databases, whilst providing a useful introduction to programming. 

VBA Development Basics 

The Access Development 

  • Environment 
  • The Importance Of Splitting Databases 
  • Maintaining Links 
  • Using Queries For Reports And Forms 
  • Understanding Client/Server 

Macros And VBA 

  • Macro Overview 
  • Creating Macros 
  • Assigning Macros 

VBA Essentials 

  • Programming Environment Overview 
  • The Role Of Forms 
  • Creating A Startup Form 
  • Understanding Modules 
  • Code Behind Forms 
  • Naming Conventions 

VBA Subroutines 

  • Creating A Subroutine 
  • Creating A Function 
  • Calling Procedures 
  • Passing Parameters 
  • Returning Values 
  • Scoping Procedures 

VBA Variables 

  • Overview Of Variables 
  • Option Explicit 
  • Default Values 
  • Scoping Variables 
  • Local Variables 
  • Module-Wide Variables 
  • Passing Parameters 
  • Passing Parameters By Value 

Debugging VBA 

  • Overview Of Debugging 
  • Setting A BreakPoint 
  • Stepping Through A Procedure 
  • Using The Locals And Immediate 
  • Adding A Watch 

Interactive VBA 

  • Creating A Simple Input Box 
  • Creating Larger Messages 
  • Breaking A Message Line 
  • Message Box Functions 
  • Responding To Different Buttons 

Decisive VBA 

  • Decisions Overview 
  • Creating An In-Line If 
  • Using Case Statements 
  • Value Ranges In Case Statements 

Looping VBA 

  • Program Loops 
  • Creating A While Loop 
  • Creating An Until Loop 
  • For Each Loops 
  • Exiting From Loops 
  • For Next Loops 

The DOCMD Object 

  • Overview Of DoCmd 
  • Moving Through Records 
  • Filtering Records With DoCmd 
  • Opening A Form With DoCmd 
  • Opening A Report With DoCmd 

Handling Errors In VBA 

  • Error Handling Overview 
  • Understanding Common Errors 
  • Creating A Simple Error Handler 





Duis egestas aliquet maecenas erat eros, fringilla et leo eget, viverpretium. Quisque sed augue tincidunt, posuere dui tempor, dapibus nisi. Donec vel lectus sapien. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas.

Free Courses

Duis egestas aliquet aliquet. Maecenas erat eros, fringilla et leo eget, viverra pretium nulla. Quisque sed augue tincidunt, posuere dui tempor.

Premium Courses

Duis egestas aliquet aliquet. Maecenas erat eros, fringilla et leo eget, viverra pretium nulla. Quisque sed augue tincidunt, posuere dui tempor.

Ready to get started?

Get in touch, or create an account

Subscribe To Our Newsletter

Join our mailing list to receive the latest news and updates from our team.

You have Successfully Subscribed!