Access VBA for Database Solutions, CMP981
Visual Basic for Applications (VBA) is an essential programming tool included in Access, Excel, and Word. VBA is used to build the sophisticated database and spreadsheet solutions routinely required by business and government. Major topics include use of Macro Groups to design and automate menus and dialogue boxes; using Visual Basic editor tools and Windows to create and modify VBA code; and 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.
Prerequisites : MS Access Levels 1 - 3, and Programming Fundamentals or equivalent experience.
Classroom Hours: 15
Textbook: Please bring your textbook to the first class session. See MC Bookstores for more information on your textbook, bring to first class along with a USB Flash Drive/memory stick (at least 512 MB).