This course is designed for students who have a basic understanding of spreadsheets, word processors, and databases as well as introductory programming experience. The course introduces methods to automate repetitive tasks and create user-friendly applications in spreadsheets, word processors, and databases using the powerful macro language, Visual Basic for Applications (VBA). Topics include: a review of programming constructs such as data types, looping, conditional statements, and arrays; the design of graphical interfaces with the typical "look and feel" of Windows software; the design of dialog boxes with controls and event handling code that responds to user input; automating tasks; consolidating data; providing user-friendly reports. Prerequisites CP102 and previous programming experience, or CP104. Notes 3 lecture hours, 1.0 lab hour
