CIS 294 Homework Four Assigned October 16, 1997

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

Use VB 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:

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 enter a student name, 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):

1. List the student name, major, and advisor name in ascending order according to class standing.

 

2. List the students in ascending alphabetical order according to last name.

 

3. Think of a good query and make a button for it. It must be multi-table.

1. Create a database using the three 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.

1. failing to meet the above specifications and requirements

 

1. failing to meet the proper program submission/documentation requirements

Student Table (variable-size, you may add and delete)

Advisor Table (fixed-size, you cannot add or delete)

Major-Department (fixed-size, you cannot add or delete)