CIS 3200 — Advanced Database Programming
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.