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
Klein
Instructor
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