Assignment using Update Program (ACDinCode1.vbp) :

  1. Explain the processing that is done in Form_Load . What gets accomplished and how?
  2. Make the changes to the program to deal with adding a duplicate course.
  3. Explain the code in Setup_stuCrs-Grid
  4. Explain the difference between adding a student and adding a course.
  5. Explain how the bookmark is used in this program.
  6. Explain the difference between changing information about a student and changing a grade. Why is the grade the only thing that can be changed? If I wanted to change something else about the course the student has taken, how would I do this?
  7. Explain the difference between deleting a student and deleting a course.
  8. Explain this code:

With rsStudents

.CursorLocation = adUseClient

.CursorType = adOpenDynamic

.LockType = adLockOptimistic

.Open SQLStudents, comStuHier, , , adCmdText

End With

 

  1. Extra credit: Explain the combo box that appears on the form. How is it used?