Dates and fees to be confirmed
This short course is designed for anyone who uses Microsoft Access and wants to discover more than the basic capabilities of Microsoft Access and connect it to other applications.
The Microsoft Access VBA programming short course teaches in-depth Microsoft Access VBA programming techniques that enable the developer to go beyond capabilities offered by basic Access usage and smooth out the rough edges that Access leaves behind.
This practical short course takes the form of a series of evening classes taking place once a week in our Central London location.
This fully hands-on evening course provides hundreds of example programs that you can modify and deploy in your own database work.
The course covers the three available object models (Access objects, DAO and ADO), explains the differences between them and how to use them confidently.
The course concludes with examples of how to extend Access to interact with the other Microsoft applications such as Excel, Word and Outlook.
Working knowledge of MS Access; basic programming as taught in VBA in Excel
You must be proficient in written and spoken English.
Teaching takes the form of theoretical explanation and pre-supplied programs to demonstrate the implementation of the theory. Short exercises take place in order to reinforce the your grasp of a topic.
The tutor is happy to answer questions and follow up your particular needs and interests where possible.
The short course assumes prior knowledge of Access and VBA, but revision materials are provided for you to follow up offline.
Sean Walsh has over 10 years’ experience of Excel and VBA. He was a member of the Support, Training and Documentation team within City’s IT department and has an MSc in Computing Science from Birkbeck.
Sean has taught other evening classes for City such as Oracle and SQL, XML, Excel and MS Office. He has also managed an academic programme within City, University of London’s Continuing Education department.