Skagit Valley College

Catalog Course Search Details

 Course Title:   Office Programming-VBA

 Title Abbreviation:   OFFICE PROGRAMMING-VBA

 Department:    CIS

 Course #:    243

 Credits:    5

 Variable:     No

 IUs:    5

 CIP:    110301

 EPC:    514

 REV:    2019


 Course Description  

Office Programming-VBA is a capstone course that explores ways to customize and improve procedures across the office suite using various tools. Topics include macros, application customization and development, object linking and embedding and cross-application development.

 Prerequisite  

Prerequisite: introductory database programming experience using VBA as presented in CIS 242 is essential. Students should be comfortable with customizing Microsoft Access queries, forms and reports to respond to runtime events.

Additional Course Details

Contact Hours (based on 11 week quarter)

Lecture: 55

Lab: 0

Other: 0

Systems: 0

Clinical: 0


Intent: Distribution Requirement(s) Status:  

Vocational Preparatory Required for ATA degree, Elective  

Equivalencies At Other Institutions

Other Institution Equivalencies Table
Institution Course # Remarks
N/A

Learning Outcomes

After completing this course, the student will be able to:

  1. Record and Edit Macros.
  2. Customize Application Menus.
  3. Embed and/or Link Objects.
  4. Use an Application to Control another Application.
  5. Write Remote Macros and Scripts.

General Education Learning Values & Outcomes

Revised August 2008 and affects outlines for 2008 year 1 and later.

Course Contents

  1. Macro Recording and Editing.
  2. Application Menu Customization.
  3. Embedding and Linking Objects.
  4. Cross Application Development.
  5. Remote Macros and Scripting.