In this course, students will learn to easily create tables, queries, forms and reports, and connect them together with macros. In this course, students will learn to use VBA to write rich solutions with advanced data manipulation and user control.
Appropriate introductory and advanced courses plus several weeks of practice. No programming experience is required
3 Days/Lecture & Lab
This course is designed for experienced Access users who want to learn ActiveX Data Objects, control structures, and the basics of VBA programming.
Getting Started::Working with Procedures and Functions::Understanding Objects::Using Expressions, Variables, and Intrinsic Functions::Controlling Program Execution::Working with Recordsets::Debugging Code::Handling Errors::Appendix - Working with the ADO Recordset Object