Visual Basic for Applications
What is VBA ?
VBA stands for Visual Basic for Applications (the application here is Microsoft Access), VBA Access represents the technology and tools used to program and automate this application.
We can use VBA Access to perform some operations:
- Manage re-usable procedures (globally).
- Create our defined functions.
- Hold variables in memory (globally).
- Attach code to an event ( button click, AfterUpdate, BeforeUpdate, etc...).
- Manage more powerful procedures that an Access macro lacks.
- Communicate with other applications and platforms (like Excel, SQL Server, etc...).
- Handle errors
- And more ...
