1.                  Study the login module in DIS622.mdb.

2.                  Rewrite the subroutine FlagUser so that it uses the new ADO technology.

3.                  Add a new user type “Administrator” in the tblUSER table and establish yourself as the administrator.  Then modify the login screen such that when a legitimate administrator login, the admin.mdb will be opened with a greeting screen.

4.                  Write a subroutine to randomly pick 5 students from the Student table without duplication and place the students selected in the tblSelected table.

5.                  Mail merge with a document in Word to send a notification letter to each of the students in the tblSelected table.

6.                  Modify the course registration form so that the student’s tuition cost will be calculated.  The tuition cost is determined as follows:

Tutition

12 credit hours or more

Less than 12 credit hours

Undergraduate

Resident

$1987.25

$158.40 per credit hour

Nonresident

$5263.25

$431.40 per credit hour

Graduate

Resident

$2173.25

$227.40 per credit hour

Nonresident

$5782.25

$628.40 per credit hour

 

7.         A simple demonstration on opening Excel from Access

 

8.         Download dataset