Access for Programmers and Application Development, CMP805

Course Description:

This course is designed to introduce the students to practical use of Macros and Visual Basic for applications (VBA) and application development that can be used to adapt Microsoft Access to the needs of the business environment and Microsoft Office applications.  Major topics to be covered in this course are:  use of Macro Groups to design and automate menus and dialogue boxes, tools and windows in the Visual Basic editor to create and modify VBA code, basic VBA program code to include module and procedure design, control and loop structures, automation of text and combo boxes, and programming methods to prevent errors.  This is a hands-on course with the software and computers.

Prerequisites:

MS Access - Level I, Level II and Level III, Programming Fundamentals or equivalent experience.

Technology update: Please bring a Flash Drive/Memory Stick 512MB or larger to class which will enable you to save your class work.

Textbook:

Books may be purchased at the MC Bookstore or online. You will need to know the CMP#(Continuing Education classes) for the class you are taking in order to look up information about the textbook.

Classroom hours: 15