Department Homepage  Course Listings Degree Options Department Information Home Department Listings eSchedule Catalog Home Home
 
Master Course Outline
CS 240
Application Integration using VBA


Credits: 5
Clock Hours per Quarter: 50

AA Discipline:

Lecture Hours:50


Description
Focuses on the functions of MS Office applications, integrating uses with Visual Basic for Applications.

Intended Learning Outcomes
  • Create the Multiple Document Interface.
  • Use Pending Events and the Idle Loop.
  • Work with the Clipboard.
  • Customize Toolbars and Status Bars.
  • Access a Database with the Data Control or the Bounds Controls and the Data Access Objects.
  • Explore the Capabilities of the JET Engine.
  • Use Structured Query Language (SQL).
  • Access non-JET Databases with the JET Engine.
  • Examine Object Linking and Embedding (OLE).
  • Create OLE Containers.
  • Use Visual Basic for Applications (VBA).
  • Demonstrate programming integration with Microsoft Excel.
  • Demonstrate programming integration with Other OLE Applications.
  • Call Dynamic Link Libraries.

  • Course Topics
  • The Multiple Document Interface
  • Pending Events and the Idle Loop
  • The Clipboard
  • Toolbars and Status Bars
  • Accessing a Database with the Data Control and the Bounds Controls
  • Accessing a Database with the Data Access Objects
  • The Capabilities of the JET Engine
  • Structured Query Language (SQL)
  • Accessing non-JET Databases with the JET Engine
  • Overview of Object Linking and Embedding (OLE)
  • Createing OLE Containers
  • Visual Basic for Applications (VBA)
  • Integration with Microsoft Excel
  • Integration with Other OLE Applications
  • Calling Dynamic Link Libraries

  • Syllabi Listing See ALL Quarters
    Course
    Year Quarter
    Item
    Instructor  
    CS 240
    Fall 2014
    0528
    Tim Burgoyne
    CS 240
    Winter 2014
    0528
    Wallace Fisher
    CS 240
    Fall 2012
    0528
    Wallace Fisher
    CS 240
    Fall 2011
    0524
    Wallace Fisher
    CS 240
    Fall 2010
    0524
    Gerald Sampson


    Two Year Projected Schedule

    Year One* Year Two**
    Fall
    Winter
    Spring
    Summer
    Mini 
    Fall
    Winter
    Spring
    Summer
    Mini
    X
     
     
     
     
    X
     
     
     
     

    *If fall quarter starts on an odd year (2003, 2005, etc.), it's Year One.
    **
    If fall quarter starts on an even year (2002, 2004, etc.), it's Year Two.