Training/course: Access VBA
Course Description
This course teaches you to develop applications for Microsoft Access. You will learn how you can use MS Visual Basic for Applications (VBA) to make your database more user-friendly. You will learn to write your own functions and procedures in VBA, and how to amend and change menus.
By the end of the course the participants will be comfortable enough with using VBA that they are in a position to build stable and user-friendly Access applications.
Course Content
The main subjects covered will be as follows:
- Amending an application using Visual Basic
- Creating Tables and Relationships
- Creating Queries
- Getting Started with Forms
- Displaying Data with Reports
- Building a Simple Application
- VBA Naming Conventions
- Useful VBA Functions
- Filtering and Searching records
- Rearranging data-input
- Code control and Trouble-shooting
- Dealing with errors and unexpected occurrences
- Collecting data in a dialogue window
- Navigating through an application
Course Prerequisites
It is essential that participants are comfortable with Access and its abilities up to and including the level or our Access Intermediate course or equivalent.
Comments
None
