Custom Search
Provided by: Mullan Training

VB Access

Computer

Mullan Training
Training Provided by Mullan Training This 2 day course is suitable for Advanced users of Microsoft Access responsible for managing very large and variable amounts of data, or teams, who want to learn how to program features and functions to improve the accessibility and usability of their data. PREREQUISITES A high proficiency of Microsoft Access is essential, or completion of our Advanced MS Access course. BENEFITS At the end of the course the delegate will have covered the fundamentals of VBA, including: working with procedures and functions understanding objects using expressions, variables and intrinsic functions. mastering how to control program execution working with forms and controls working with the PivotTable object. Debugging code handling errors to ensure minimal downtime while building and effecting the program. COURSE CONTENT The VBA Programming Environment When to use Visual Basic for Applications instead of Macros Visual Basic for Applications Development Environment Programming in the VBA Language Code Compilation Finding Bugs Error Handling in VBA Ignoring Errors Trapping Errors Writing Useful Error Handlers Class Modules and Form-Event Procedures Using Form Events Code Behind Forms Changing Form Properties Creating New Form Instances Manipulating Data through Data Access Objects and SQL Data Access Objects (DAO) Opening Databases Programmatically Database and Recordset Objects Manipulating Data with VBA Methods Finding Records in a Recordset Editing Data in a Recordset Using Recordsets to Manipulate Imported Data Creating, Using and Deleting Queries from VBA Changing Database Definitions through VBA Using SQL to Manipulate Databases LOCATIONS Courses can be delivered at our offices in Belfast city centre (opposite the Europa Hotel) or in your own workplace (where we can provide 8 laptops, projector & flipcharts). ADDITIONAL INFORMATION If you would like more information please do not hesitate to contact us. For a course outline visit our website www.mullantraining.com or email us at info@mullantraining.com or telephone 0289032 2228
This is primarily ilt training
computer labComputer Lab Work
group study and discussionThis class may involve group study
coursewareCourseware may be available for purchase
instructor led trainingThis class may be available at a classroom in Belfast, Co Antrim, or at one of these training facilities: Belfast, Antrim,
Contact Mullan Training for more information
Course Level:introductory
Duration:2 days
Training Presented in:English
About The Training Provider: Mullan Training
Mullan Training - Mullan Training are a computer training company in Belfast city centre. We deliver high quality computer training in Belfast and throughout Northern Ireland. We can deliver computer training courses in our training suites OR in your own offices. We are an authorised Microsoft Office Specialist (MOS) Testing Centre so delegates can prepare for & sit exams with us. Courses we deliver...
Do you teach computer ?
tcw11-gfc-v396M-11/02/09-12:30:42-()[A]-[B]-[A] -14:50:47