CPGM 220 - Advanced Visual Basic

3 Credit: (2 lecture, 1 lab, 0 clinical) 3 Contact Hours: [CPGM 130 ]

Visual Basic will be used to code programs for advanced business solutions. These programs will include an interface (OLE) to other programs, databases, and business reports. The coding of error handling routines will be required and include string manipulation, arrays, working with Access files, classes and objects and building a Web page.
OFFERED: fall semesters

Course Goals/ Objectives/ Competencies:
Goal 1: Demonstrate understanding of Advanced Visual Basics concepts by creating error free programs.

Create code using Arithmetic operators.
Create code using Constants.
Create code using Strings.
Create code using Statements.
Employ User Defined Data Types.
Employ Numeric Data Types.
Create parallel arrays.
Create two-dimensional arrays.
Demonstrate Exception handling.
Determine number of characters in a string.
Insert Characters in a string.
Search Strings.
Access Strings.
Remove Characters from a string.
Compare strings with pattern matching.
Develop invoking functions.
Demonstrate Passing by value.
Demonstrate passing by reference.

Goal 2: Create Access databases.

Create sequential Access files.
Bind Access databases.
Create Try/Catch statement.
Copy to Output.
Bind objects to controls.
Code Next record buttons.
Code Previous record buttons.
Create Linq Queries.

Goal 3: Create Classes.

Create Default Constructor.
Create classes using Non-constructor methods.
Create an instance.
Create class level arrays.
Create class level variables.

Goal 4: Create Web Applications.

Add web pages.
Add static text to web pages.
Add link buttons to web pages.
Add images to web pages.
Add text boxes to web pages.
Add labels to web pages.
Add field validation.
Add buttons to web pages.