Access VBA Macros
Categories: Microsoft Access
Need course dates or locations to suit you? CLICK HERE TO SEND ENQUIRY...  
Access VBA Macros Training

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
 
Need course dates or locations to suit you? CLICK HERE TO SEND ENQUIRY...  
My Location
Results for location are highlighted in the table below. Click here to remove highlight
The course either has new dates in data loading, or is only run as a dedicated or In Company course.
Tools
 
Key Details
Duration2 days
 
£525
per delegate
 
 
Bookings Helpline: 01933 233884 (Monday to Thursday - 8:00am to 5:30pm and Friday 8:00am to 5:00pm).