The MS Access - Programming with VBA training course provides skills to use the VBA (Visual Basic for Applications) programming language to automate the database applications. You will learn about creating Sub Procedures and Functions and see how to call these blocks of code from an event occurring in Microsoft Access, such as a button being clicked or a user saving a record. You will be introduced to the Microsoft Access Object Model, which will allow to control all aspects of the application, including things like closing or opening forms, printing reports or validating user data entry. You will also be introduced to accessing data in the database through code by using Data Access Objects (DAO,) allowing the manipulation of data behind the scenes - with no user action needed. Finally, you will see how to debug the code and add error handling to ensure that unexpected errors don't force an application shutdown.
By attending MS Access - Programming with VBA workshop, delegates will learn to:
- Create Sub Procedures and Functions
- Attach code to user-initiated or application-initiated events
- Control program flow by using If/Then and Looping structures
- Access and modify data in the database directly using code
- Debug code to find and fix programming errors
- Implement error-handling code to catch and resolve run-time errors
- Experience in creating and using tables, forms, reports and queries in Microsoft Access.
- No programming experience is necessary.
This MS Access - Programming with VBA class is designed for experienced Access developers who want to make a start on VBA (Visual Basic for Applications) in order to produce databases to professional standards.