ISYS-306: Advanced Database

This class teaches you to create visual applications using a variety of database platforms, such as MS-Access, dBASE and others.

Class Schedule and Notes

Session/Week Topics/Exams Text and Chapters
Session 1 Introduction, review of database structure. Chapters 1-5
[Class 1 MDB for 2000/XP]
[Class 1 MDB for 97]
Session 2 SQL & data enntry.
Connections
Chapter 6
[Class 2 dBase Example][Class 2 MDB for 2000/XP]
[Class 2 MDB for 97]
Session 3 Data Validation
Objects
Project ideas due
Chapters 7,8
Session 4 Mid-Term Exam [Mid-Term Example for 2000/XP]
[Mid-Term Example for 97]
Chapter 6
Session 5 Review exam
Searching and sorting queries
[Class 5 MDB for 2000/XP]
[Class 5 MDB for 97]
Session 6 Creating reports Chapter 11
Session 7 Creating applications Chapter 12
[Class 7 MDB for 2000/XP]
[Class 7 MDB for 97]
Session 8 FINAL EXAM: Present your topic  

Other Links