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.