Access 2007 Visual Basic
Categories: Microsoft Access
Access 2007 Visual Basic

Course Contents
The contents of our Access 2007 Visual Basic course are as follows (any items marked with a * will be covered if time allows).

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!

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

Modifying queries
• Basic SQL statements
• Amending queries' SQL

Recordsets
• Choosing ADO or DAO
• Adding data
• Editing data
• Deleting data

Debugging and error handling
• Stepping through macros
• Setting breakpoints
• Trapping for errors

Linking to Excel and Word (*)
• Referencing other applications
• Manipulating Excel from Access
 
Tools
 
Key Details
Duration2 days
 
£625
per delegate