CIS 294 Homework	Four			Assigned February 26, 1997

As stated on the syllabus, all of the programming assignments combined are worth a total of 30% of your final grade.  This assignment will be worth 15 points, or 25% of the 30% for all the assignments.  This assignment is to be done individually.

I.	Programming assignment:  (15 points)

Due:		March 19, 1997

User specifications:

Use VB 4.0 to allow a user to manipulate a database according to the following:

1. Allow the user to scroll through the list of students while showing student name, standing, advisor name, and major.  I am looking for a form that is very similar to what is shown on page 446 in the text.
 
2. Allow the user to add a record, delete a record, and update an existing record for the four fields.  For example, the user should be able to add the following student:
 
Name:	Carol Smithers
Standing:	3 (this will bump the existing standing of 3 and all subsequent students down by one)
Advisor Name:	You can't add a new advisor, but one will be assigned automatically when a major is declared.(read-only)
Major:	You can't add a new major, but choose from the existing list.(read-only)
 
3. Deleting and updating records may affect other records.  Namely, the class standings will change as people are added, deleted, and updated.  This needs to work correctly.
 
4. When a user adds a new student, a new student ID should be assigned automatically.  Don't reuse old student IDs from deleted students.  It is up to the user to assign a major and give the student a class standing.
 
5. Use the Data Control and SQL commands to allow the user to perform the following queries (that you have "hard-wired" to command buttons):

A. List the student name, major, and advisor name in ascending order according to class standing.
 
B. List the students in ascending alphabetical order according to last name.
 
C. Think of a good query and make a button for it.  It must be multi-table.

Program requirements:

1. Create a database using the four tables seen on the following page.  It must be a Microsoft Access database created either by using Access or by using the Data Manager from within VB.
 
2. Be careful to check for proper input and do not allow users to go to blank records, as discussed on page 492 of the text.
 
3. You must center all forms on the screen using a common procedure.
 
4. You must have an "About" dialog that is modal and gives a brief description of who you are and what your program does.  (Place this under the Help menu item where it usually goes.)
 
5. You need to provide a way to exit the program gracefully.
 
6. You must use proper naming conventions for forms and controls (see appendix B).
 
7. You must create an executable file (.EXE) and use the Setup Wizard to submit the assignment on disk(s) to me.

Points will be deducted for the following:

1. failing to meet the above specifications and requirements
 
2. failing to meet the proper program submission/documentation requirements