CIS 3200 - Advanced Database Programming

4 Credit(s) Hours: 4 hrs.

Building on concepts covered by the CIS 3100 (Introduction to Database) course and using VBA as the underlying programming language, this course focuses on accessing data contained in a typical database system and extracting and manipulating such data through code and the SQL language. Also covered are concepts of looping datasets, decisions using If/Then/Else and case statements. Both DAO and ADO data access methods are utilized and the code snippets needed to manipulate various controls of a typical presentation layer are covered.
Prerequisite(s): CIS 3100
Department: Mathematics and Computer Science