The Student Form

This screen will be shown in Access after the ‘OK’ button is clicked on the dialog box. As shown in Fig. B3, all of the tables are linked through the unique ID’s created by Access when records are created. In this form, students can be browsed, and the details for each of the things that the student is linked to can be viewed.

Validation of this form:

• Student ID - Must be text and less than 30 characters
• First Name - Must be text and less than 20 characters
• Last Name - Must be text and less than 20 characters
• Email - Must be less than 30 characters
• Grad Year - Must be above 2010
• House - Must be one of the specified choices

For your listening pleasure