Call us today: 0800 028 3045
Microsoft Access Developer Course – VBA in Access Part 2 – Access Objects & DAO
Is it right for me?
Our VBA in Access Part 2 course is designed for existing experienced users of Access. You must be able to confidently create fully relational databases including tables, forms, reports and queries before attending this course.
Basic VBA experience is required. This can be gained by attending our VBA in Access Part 1 - Automation course.
What will I get out of it?
By the end of the course you will be able to:
- Use the Access Object Model
- Use the DAO - Data Access Object - Model
- Transfer information to Word and Excel
Versions available
2003, 2007, 2010
Related courses in our range
What does it cover?
Variables and arrays
- Review of variables
- Creating arrays
- Using arrays
Looping
- Do While
- Do Until
- For Next
Nested control structures
- Using loops and conditionals
The Access Object model
- Collections
- The For Each . . . Next Loop
- Using TypeOf
- Dynamic list boxes
Data Access Objects
- Data Access Object model
- Collections
- Using containers
DAO recordsets
- Opening recordsets
- Manipulating recordsets
- Navigating and positioning in recordsets
- Counting records
- Finding records
DAO - QueryDefs
- Creating QueryDefs
- Working with SQL
Sharing data with other applications
- Setting references to other applications
- Interacting with Word
- Word VBA commands
- Interacting with Excel
- Excel VBA commands
Course Summary
Send to a colleague
Please enter details below and click 'submit'
Tailor this course
If you are interested in this course but would like it tailored to your specific needs, contact Karen Osborn on 0800 028 3045.
Alternatively, enter your details below and one of our team will contact you.
Thales Training & Consultancy is a highly successful training services company based in Crawley. We help companies to develop advantage through learning and development. Highly trusted by leading enterprises, we deliver a full range of dedicated training solutions that enable organisations to achieve key business goals. The 4 core services we offer are Training Courses, Supply Management, Bespoke Services and Managed Services. Our successful partnerships with clients prove that the delivery and management of the right training and development can significantly enhance the pursuit of business excellence.
