CAS 260: Office Application Development
Course Description
Provides students with an opportunity to build productivity applications using a currently popular applications suite and macro language. Advanced word processing, spreadsheet, and database features are included, with a focus on integrating applications and automating everyday tasks. Recommended preparation: CAS 160 and CIS 101 or equivalent experience.
Course Outline
- Recording Your First Macro
- Writing Your Own Macros
- Understanding Program Variables
- Building VBA Expressions
- Working with Objects
- Controlling Your VBA Code
- Programming Word
- Programming Excel
- Programming PowerPoint
- Programming Access Databases
- Programming Outlook Email
- Interacting with the User
- Creating Custom VBA Dialog Boxes
- Creating Custom Menus and Toolbars
- Debugging VBA Procedures
Required Materials
- Textbook
- Internet access and a Harper Blackboard account.
- Access to a computer running a licensed or trial version of Microsoft Office 2007 Professional or Office 2003 Professional as a complete installation including Word, Excel, PowerPoint, Access, Outlook, and Office VBA. Harper lab I 205 has computers and software that may be configured as necessary for this course.
Faculty Contact
For questions about this course contact the department coordinator:
Dave Braunschweig
dbraunsc@harpercollege.edu
847.925.6817