Access 2007 Visual Basic
Categories: Microsoft Access
Need course dates or locations to suit you? CLICK HERE TO SEND ENQUIRY...  
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
 
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
 
£625
per delegate
 
 
Bookings Helpline: 01933 233884 (Monday to Thursday - 8:00am to 5:30pm and Friday 8:00am to 5:00pm).