|
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 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.
printable version
|
|
