CSE1IS Information Systems
Tutorial - Week 8
Tutorial 2 - Input Design
-
Shelly, Cashman and Rosenblatt - p.290 Discussion Topics
1.
-
Shelly, Cashman and Rosenblatt - p.291 North Shore Boat
Sales - Questions 2 & 4.
-
S.C.& R. page 294, Video Superstore Assignments.
-
Design a screen for the entry of Students’ results
into the Lecturer’s Student Record System that your
Access tutorials are based on ...
-
The screen will be based on the Student and Result
tables.
-
Ensure that you can navigate from student to student
and also select a student effectively (from a
comboBox?).
-
Display all of the results for the current student
-
Allow for the editing of the result for an assessment
-
Do you need to be able to edit a student’s
personal details in this screen?
-
Do you need to be able to add/delete students?
-
Do you need to be able to add new assessmensts?
-
Do you need to be able to edit assessment details?
-
What if a mark entered is greater than the maximum mark
of the assessment?
-
Don’t forget the Save, Reset and Exit buttons
-
Try to improve on the design shown in the next tutorial
of these notes.
-
Design a screen for student maintenance in the
Lecturer’s Student Record System.
-
The screen will be based on the Student table, plus
some additions listed below.
-
Ensure that you can navigate from student to student
and also select a student effectively (from a
comboBox?).
-
Use a comboBox(?) to select a tutorial
-
Add the following fields to your screen design be
careful to choose appropriate controls:
-
Gender (Male or Female)
-
Date of birth
-
Address = street, town, state and postcode
-
Choice of government (HECS) or full fee paying
-
Annual Fee
-
Don’t forget the Save, Cancel, Reset and Exit
buttons
