|
Official Course
Description: MCCCD Approval:
2-27-2001 |
||
|
CIS169 2001 Summer I – 2002 Summer II |
L+L
3.0 Credit(s) 4.0 Period(s) 3.7 Load Acad |
|
|
Introduction
to Visual Basic for Applications |
||
|
Introduction to Visual Basic for Applications (VBA) using
Microsoft Office environments. Includes Dynamic Data structures, VBA class
modules and error trapping and handling. Creation of customized office
applications and network shares as well as multimedia techniques also
covered. Prerequisites: CIS159 or permission of Instructor.
|
||
|
|
||
Go to Competencies Go to Outline
|
MCCCD
Official Course Competencies: |
|
|
|
|
|
CIS169 2001
Summer I – 2002 Summer II |
Introduction to Visual Basic for Applications |
|
1.
|
Explain how Visual Basic for Applications (VBA) stores
strings. (I) |
|
2.
|
Differentiate between Unicode and Ansii
code. (I) |
|
3.
|
Use built-in string functions. (I) |
|
4.
|
Format specific dates. (II) |
|
5.
|
Use built-in numeric functions. (III) |
|
6.
|
Create customized math and numeric functions. (III) |
|
7.
|
Sort and search using Arrays. (IV) |
|
8.
|
Create a class object. (V) |
|
9.
|
Summarize how a class module functions. (V) |
|
10.
|
Create various Dynamic Data Structures using class
modules. (VI) |
|
11.
|
Use error-handling routines. (VII) |
|
12.
|
Use debugging tools. (VII) |
|
13.
|
Explain the VBA IDE Object Model. (VIII) |
|
14.
|
Retrieve and set system information. (IX) |
|
15.
|
Use VBA registry functions. (X) |
|
16.
|
Summarize characteristics of the Windows Networking
Application Programming Interfaces (API). (XI) |
|
17.
|
Perform file Input/Output (I/O)
within a VBA application. (XII) |
|
18.
|
Create an application using Windows multimedia. (XIII) |
Go to Description Go to top of
Competencies
|
MCCCD
Official Course Outline: |
|
|
|
|
|
CIS169 2001
Summer I – 2002 Summer II |
Introduction to Visual Basic for Applications |
|
I. Strings A. Overview B. Storage C. Unicode vs. Ansii D. Functions E. Substrings II. Dates and Times A. Overview B. Built-in Date Functions C. Finding Specific Date D. Manipulating III. Numbers A. Built-in Functions B. Custom Functions IV. Searching and Sorting A. Overview B. Arrays V. Visual Basic Application
(VBA) Class Modules A. Overview B. Creation C. Function D. Property Statements VI. Dynamic Data Structures
A. Overview B. Purpose C. Components D. Creation E. Implementation VII. Professional
Development A. Overview B. Error-Handling Routines C. Debugging Tools VIII. VBA (IDE) A. Object Model B. Automation Server C. Implementation IX. System Information A. Purpose B. Using Classes C. Using Application
Programming Interfaces (APIs) D. Retrieving Information E. Setting Information X. Registry A. Structure Overview B. Functions C. Object Model XI. Windows Networking API A. Overview B. Basic Network
Functionality C. Advance Network
Functionality XII. Disks and Files A. Built-in Functions B. Windows API Functions C. Directories/Files Object
Model XIII. Multimedia A. Overview B. Purpose C. Interface D. Adding to an Application
|