Access VBA macros training course (2 days)
If you have mastered tables, queries, forms and reports in Access, it is maybe time to learn Access programming. This two-day course shows you how to use Access VBA to automate your databases, making your database development easier - and more fun!
Access VBA macros training - Course Contents
The contents of our Access VBA macros course are as follows (any items marked with a * will be covered if time allows):
The VBA code editor
- Two ways to create modules
- Using Project Explorer
- Basic subroutines and comments
Messages and variables
- The all-powerful DoCmd object
- Displaying messages
- Getting input from users
- Using variables
Creating functions
- Passing arguments
- Returning values
Visual Basic explained
- Objects and collections
- Methods and properties
- The Access object model
- Getting help in VBA
Attaching code to forms
- Attaching code to buttons
- Attaching code to events
- Making code not form-specific
- Manipulating form/control properties
Looping
- The four types of loop
- Looping over all open forms
- Looping over controls
- Looping over Access Objects
|
Recordsets
- Choosing ADO or DAO
- Adding data
- Editing data
- Deleting data
Debugging and error handling
- Stepping through macros
- Setting breakpoints
- Trapping for errors
Case studies
- Navigation buttons
- Creating a simple menu
- Validating forms
- Criteria forms
Linking to Excel and Word (*)
- Referencing other applications
- Manipulating Excel from Access
Modifying queries (*)
- Basic SQL statements
- Amending queries' SQL
|
Click on any link above to show free exercises for the topic in question. Delegates should only attend this course if they have a good working knowledge of Access basics, and if they are proficient computer users. Experience of programming, while useful, is not essential. There will be a maximum of 6 people on each course, and each person will have their own computer.
