Answer all 9 questions.


For questions 1 to 8, use the "Print Screen" button and WORD to capture screen shots of the design view of each of your forms, save each answer to disk. For each question submit a screen shot of the relevant parts of the design view of the form, do this by pasting the screen shot into a word document. Ensure that each question is numbered and titled (e.g. Ex.4.1 "Add and Edit Records").


Send an e-mail to your tutor when you have finished the menu system required for question 9.


You will be required to demonstrate that your forms work to your tutor by showing the on screen versions.

 

Question 1

Design a form to allow a user to add and edit records. Display all of the Data fields. Use a Datasheet form layout.

 

Save the form as "Students - Full Edit"


Question 2

Design a form to allow a user to add and edit records. Display only the fields SREF, INIT, SNAME and HTOWN. Use a columnar layout.

 

Save the form as "Students - Edit Name & Town"

 

Question 3

Design a Form to allow a user to view (i.e. NOT change, add or delete) the following data fields SREF, INIT, SNAME, KIDS, HTOWN. Select a columnar format.

 

Save the form as "Students - Town & Children (Read Only)"

 

Question 4

Design a form to allow the user to view (on a read only basis) All of the fields in STUDREC. Your Form should contain a calculated field that displays the age of the student in years. Select a columnar format.

 

Save the form as "Students - Age (Read Only)"

 

Question 5

Design a read only form that displays all of the data fields in STUDREC. Add a calculated field that displays the word "LOCAL" is the student lives not more than 12 miles from the College, otherwise display the phrase "Not Local". Select Columnar layout.

 

Save the form as "Students - Local-Non Local (Read Only)"

 

Question 6

Design a form that is based on the query RESIDENT and allow the user read only access to all resident students.

 

Save your form as "Resident Students (Read Only)"

 

Question 7

Design a form to allow a user to edit only the RES field for those students who do not live in Barnsley.

 

Save your form as "Change residential status (not Barnsley)"

 

Question 8

Create a form that allows users to add records but not delete them or to edit existing records. Test your form by using it to add the following:


SREF=42 (assuming that you have already got records 1 to 41 in your table).
INIT= J
SNAME=CHESTER
DOB= 15/05/60
GENDER=M
RES=No
KIDS=0
HTOWN=BARNSLEY
DISTANCE=3


Save your form as "Add Student Details"

 

Question 9

Complete the "Main Menu" form as described in this section and ensure that all of the required sections of the form work).