Advanced Database Techniques
CIS-2229
|
|
Advanced Database Techniques CIS-2229 |
Course Description: Provides a study of databases. Topics include: advanced database concepts; data integration concepts, development of user interfaces; troubleshooting databases; development of macros; and related database concepts.
| Class hours per week: | 4 |
| Lab hours per week: | 4 |
| Course credit hours: | 6 |
| Course prerequisites: | CIS-106, SCT-100 |
|
Current Textbook |
|
|
|
Microsoft Access 2007, Comprehensive Edition Joseph J. Adamski, Kathy Finnegan , Authors ISBN: 1-4239-0589-X Thomson Publishers Reference material for this textbook may be found at www.course.com |
Things to expect in this class: Get ready to dive into databases in a big way. We will review the basics, tables, forms, reports and queries. From there we will explore why a field belongs in a table (the normalization process), and relationships between tables. We will place controls on forms and attach macros to them. Similar to CIS-2228, we will look at pivot tables and charts. We will also explore how databases can be manipulated using Visual Basic for Applications. From web pages that access databases to encrypting and decrypting databases, we will cover all the topics and round out your database skills. You can expect several database projects as well as written and interactive tests over the concepts.
Click here to view the current course syllabus.
last updated on 04/12/2008
