Course Syllabus

1. Introduction to Visual Basic
   1. Constants (Boolean, Integer, Long, Single, Double, Currency, Date, String, Variant)
   2. Public and Private
   3. Declaring variables (names, types, public/private, default values)
   4. Assignment statement
   5. Arithmetic expressions
   6. MsgBox function
   7. InputBox function
   8. Logical Operators
   9. Comparison operators
   10. if...then... else... end if
   11. if...then...end if
   12. Select case statement
2. Loops in Visual Basic
   1. Do While condition... loop
   2. Do ... loop until condition
   3. For var = start To end{Step increment} ... Next var
   4. For Each element In group ... next element
   5. DoEvents
   6. Nested loops
   7. Testing for sentinel values
3. Testing and debugging your Code
   1. Using the Debug window
   2. Stepping through a program
   3. Using the Calls dialog box to trace procedure calls
4. Subroutines and Functions
   1. Subroutines and functions without parameters
   2. Value parameters
   3. Name parameters
   4. Built-in procedures
5. Arrays
   1. Declaring one dimensional arrays
   2. Assigning values to an array
   3. Passing arrays to procedures
   4. Sequential search
   5. Sorting algorithm
6. Dialog boxes
   1. Built-in dialog boxes
   2. Custom dialog boxes
7. Algorithms
   1. Sequential Search
   2. Finding minimum/maximum
   3. Bubble Sort
   4. Binary Search (optional)
   5. Selection Sort (optional)
8. Visual Basic and Access databases
   1. Active X controls
   2. Records in database tables
   3. Reports from database tables

Note

Five to seven Visual Basic assignments will be given during the semester.