Creating the University Database Application

As with most technologies and software tools, continued practice or exercises help users gain a more in-depth understanding of how the software or tool can be used. The current chapter continues to demonstrate the use of Microsoft Access in not only a developing complex database system but in providing application functionality as well. Using the physical data model for a University environment developed in Chapter 4, the current chapter shows in detail how to use Microsoft Access to

Create the tables and indexes shown in the physical data model

Create Referential Integrity constraints for those tables

Create an input screen to enroll new students to the university

Create an input screen to enroll students in a class

Create an input screen to enter grades for homework

Create an input screen to enter midterm and final grades

The design of each input screen shows how to automate command sequences to use pull-down windows and form commands to take information entered on forms, save what was entered, and reset the form for the next entry to be made.