Access VBA
Short course
Inhouse
Description
-
Type
Short course
-
Level
Intermediate
-
Methodology
Inhouse
-
Class hours
12h
-
Duration
2 Days
-
Start date
Different dates available
If you have mastered tables, queries, forms and reports in Access, it is maybe time to learn. This two-day course shows you how to use Access VBA to automate your databases, making your database development easier - and more fun! Suitable for: This Access VBA macros course is aimed primarily at businesses and public sector organisations
Important information
Documents
Facilities
Location
Start date
Start date
About this course
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.
Reviews
Subjects
- The VBA code editor
- Messages & variables
- Creating functions
- Visual Basic explained
- Attaching code to forms
- Looping
- Recordsets
- Debuggin and error handling
- Case Studies
- Linking to Excel & Word
Teachers and trainers (3)
Andrew Gould
Senior Trainer
Andy Brown
Microsoft Trainer & Programmer
David Wakefield
Director / Programmer / Trainer
Course programme
- Two ways to create modules
- Using Project Explorer
- Basic subroutines and comments
- The all-powerful DoCmd object
- Displaying messages
- Getting input from users
- Using variables
- Passing arguments
- Returning values
- Objects and collections
- Methods and properties
- The Access object model
- Getting help in VBA
- Attaching code to buttons
- Attaching code to events
- Manipulating form/control properties
- Making code not form-specific
- The four types of loop
- Looping over all open forms
- Looping over controls
- Looping over Access Objects
- Choosing ADO or DAO
- Adding data
- Editing data
- Deleting data
- Stepping through macros
- Setting breakpoints
- Trapping for errors
- Navigation buttons
- Creating a simple menu
- Validating forms
- Criteria forms
If time
Linking to Excel and Word- Referencing other applications
- Manipulating Excel from Access
If time
Modifying queries- Basic SQL statements
- Amending queries' SQL
Additional information
Contact person: Rachel Brook
Access VBA
