Course Overview
***This course will run once per year in the Fall Term*** This course provides proficient MS Office end-users with an introduction to VBA, the Visual Basic for Applications programming language. VBA allows you to customize, automate and integrate office applications such as MS Word, Excel, Access, PowerPoint and Outlook. Many non-Microsoft office applications such as Visio, AutoCAD, M.Y.O.B. and others also support VBA. Students will learn to customize and integrate applications to increase productivity and reduce end-users.
Prerequisite(s)
- 50% in COMP 1200
Credits
3.0
- Retired
- This course has been retired and is no longer offered. Find other Flexible Learning courses that may interest you.
Learning Outcomes
Upon successful completion, the student will be able to:
- Recognize the components of the Visual Basic Editor.
- Refer to the objects contained in an application's object model.
- Work with and understand object variables.
- Format an Excel worksheet Word document and Access report using VBA code.
- Work with string variables and built in functions.
- Work with date and numeric variables.
- Understand selection and looping structures and how they apply to VBA.
- Use the dialog boxes contained in the Excel and Word Dialogs collections.
- Perform Automation.
- Use the SQL SELECT statement in Excel, Word, and Access to select records.
- Use the MailMerge object in Word to create labels.
Effective as of Fall 2003
Programs and courses are subject to change without notice. Find out more about BCIT course cancellations.