|
Provided by: Wise Owl Business Solutions Ltd Access VBA MacrosAccess |
 |
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!
For a full list of course topics, see our website
For a full list of course topics, see our website
Related Software Programs or Products: Microsoft Access
|
|
||||||||||||||||
Training
Provided by Wise Owl Business Solutions Ltd
- S asked: I am looking for VB training for Access . I need to automate my database by using visual basics. I have had no training in VB so would need to start as a biginner. Can you give me information and pricing on your training?
Access VBA Macros
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
Manipulating form/ control
Properties
Making code not form-specific
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
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
Manipulating form/ control
Properties
Making code not form-specific
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
About The Training Provider: Wise Owl Business Solutions Ltd
Wise Owl Business Solutions Ltd - Looking for friendly but professional scheduled or onsite Microsoft training in the UK? We deliver courses in Access, Excel, Visual Basic, ASP. NET, PowerPoint, FrontPage, Word, Project at all levels.
If you want: a choice of venues (or if you want onsite Microsoft training, a company prepared to visit your premises to discuss your needs), experienced trainers who know their subject, clear...
