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
- Access Visual Basic
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