CSCI A114 / INFO I111
Course Syllabus

First semester 2000-2001


We believe that whatever we learn we learn by doing.

Therefore the lab modules are going to be a central part of this course. We are going to follow the Shelly Cashman Pratt book Microsoft Access 2000 (Comprehensive Concepts and Techniques) in the lab and we will undertake the following projects.

ONE
Creating a Database Using Design and Datasheet Views

TWO
Querying a Database Using the Select Query Window

THREE
Maintaining a Database Using the Design and Update Features of Access
Publishing to the Internet Using Data Access Pages

FOUR
Report, Forms, and Combo Boxes

FIVE
Enhancing Forms with OLE Fields, Hyperlinks, and Subforms
Creating an Application System, Using Macros, Wizards, and the Switchboard Manager

SIX
Creating a Report Using Design View

SEVEN
Customizing Forms Using Visual Basic for Applications, Charts, and PivotTable Objects

EIGHT
Administering a Database System

While the focus will be on real-life applications, the lectures will also try to provide adequate theoretical background. Obtaining Access proficiency will provide students with significant immediate and short-term benefits. Here is a list of topics that will be presented in the lectures with the long-term benefit of the student in mind:
BASIC CONCEPTS
An Architecture for a Database System
An Introduction to Relational Databases

THE RELATIONAL MODEL
Relational Data Objects: Domains and Relations
Relational Algebra
Relational Calculus
The SQL Language

DATABASE DESIGN
Functional Dependencies
Normalization
The Entity/relationship Model

DATA PROTECTION
Recovery
Concurrency
Security
Integrity

FURTHER TOPICS
Object-Relational DBMSs: The Next Great Wave

We hope this combination will provide students with the right mix of theoretical and practical skills.


Last updated: September 1, 2000 by Adrian German for A114/I111