Send More Info
Apply Now
Classroom Login
Call Now
Call Now 855-300-1469

CIS 2501 Advanced Visual Basic


Course Description

This course covers the launch and effective navigation of Visual Basic 6 IDE. Course also includes rapid prototype user interface applications (tool tips, exception handling, and error messaging), compiling and distributing executable applications, linking to external databases, and the use of SQL select queries. Also includes object-oriented programming.

Course Objectives

Upon completion of this course, students should be able to

  • Effectively create and call a sub procedure
  • Pass data by value and by reference to a procedure
  • Explain the difference between a sub procedure and a function procedure
  • Effectively create and invoke a function procedure
  • Explain the purpose of and create a one-dimensional array
  • Store data in a one-dimensional array
  • Search a one-dimensional array
  • Create parallel one-dimensional arrays
  • Declare a module-level variable and a module-level array
  • Create a two-dimensional array
  • Store data in a two-dimensional array
  • Search a two-dimensional array
  • Sum the values in a two-dimensional array
  • Create a structure
  • Understand the advantages of using a structure
  • Pass a structure variable to a procedure
  • Create an array of structure variables
  • Open and close a sequential access file
  • Write information to and read information from a sequential access file
  • Determine whether a sequential access file exists
  • Test for the end of a sequential access file
  • Determine the number of characters in a string
  • Manipulate and work with strings
  • Define the terms used when talking about databases
  • Connect an application to a Microsoft Access database
  • Bind table and field objects to controls
  • Customize a DataGridView control
  • Handle exceptions using the Try…Catch statement
  • Position the record pointer in a dataset
  • Query a dataset using LINQ (use the LINQ aggregate methods)
  • Define a class
  • Instantiate an object from a class that you define
  • Add Property procedures to a class
  • Include data validation in a class
  • Create a default constructor
  • Include methods in a class

Week 1


Lecture: Sub Procedure, Functions and Procedures

Outcomes

  • Create a sub procedure
  • Call a sub procedure
  • Pass data by value to a procedure
  • Pass data by reference to a procedure
  • Explain the difference between a sub procedure and a function procedure
  • Create a function procedure
  • Invoke a function procedure

Week 2


Module: One-Dimensional, Parallel, and Dynamic

Outcomes

  • Explain the purpose of an array
  • Create a one-dimensional array
  • Store data in a one-dimensional array
  • Sort the contents of a one-dimensional array
  • Search a one-dimensional array
  • Create parallel one-dimensional arrays
  • Declare a module-level variable
  • Declare a module-level array
  • Utilize a dynamic one-dimensional array

Week 3


Module: Two-Dimensional Arrays

Outcomes

  • Create a two-dimensional array
  • Store data in a two-dimensional array
  • Search a two-dimensional array
  • Sum the values in a two-dimensional array

Week 4


Lecture: Structures

Outcomes

  • Create a structure
  • Declare and use a structure variable
  • Understand the advantages of using a structure
  • Pass a structure variable to a procedure
  • Create an array of structure variables

Week 5


Lecture: Sequential Files

Outcomes

  • Open and close a sequential access file
  • Write information to and read information from a sequential access file
  • Determine whether a sequential access file exists
  • Test for the end of a sequential access file

Week 6


Lecture: String Processing

Outcomes

  • Determine the number of characters in a string
  • Remove spaces from the beginning and end of a string
  • Replace characters in a string
  • Insert characters in a string
  • Search a string
  • Access characters in a string
  • Compare strings using pattern-matching

Week 7


Lecture: Databases and Querying Using LINQ

Outcomes

  • Define the terms used when talking about databases
  • Connect an application to a Microsoft Access database
  • Bind table and field objects to controls
  • Customize a DataGridView control
  • Handle exceptions using the Try…Catch statement
  • Position the record pointer in a dataset
  • Query a dataset using LINQ
  • Use the LINQ aggregate methods

Week 8


Lecture: Class Concepts

Outcomes

  • Define a class
  • Instantiate an object from a class that you define
  • Add Property procedures to a class
  • Include data validation in a class
  • Create a default constructor
  • Include Methods in a class

The course description, objectives and learning outcomes are subject to change without notice based on enhancements made to the course.