Answer all ten questions.

Submit printed copies of all ten reports to your Tutor not more than one week after this exercise was set

.

Ensure that your name is on all answers and that each report has the question number written on it.

 

Ensure that your answers are submitted in numerical order from 1 to 10.

 

Design, create and print a copy of the following reports: It is is important that you save your reports under the file names given in each question as we will be referring to these files later in the course.

 

If you find that any data fields do not fit on the page, amend your report so that they do.

 

Question 1

Design a Report to list all students, do NOT list SREF or DOB.

Save your Report as "ALL STUDENTS - No Dates"

 

Question 2

Design a report to list all students, only list Initials, Surnames, and dates of Birth.

Save your report as "All Students - Dates of Birth"

 

Question 3

Design a Report to list all students

Group the report by Home town.

Save your report as "All Students by Home Town"

 

Question 4

Design a Report to list all students by alphabetical order of name.

Save your report as "All Students- By Name"

 

Question 5

Design a report to list all students by date of birth starting with the youngest first through to the oldest last.

Only include the fields DOB, INIT and SNAME in your report. Make sure that the fields are displayed in that order across the page.

Save your report as "All Students - By Age"

 

Question 6

Design a report that lists all students and sub divides the report into Home towns and further into male/female sub groups.

Save your Report as "Home Towns/Gender"

 

Question 7

Design a report to list only men from Leeds or Barnsley. Make sure that you include all fields.

Save your report as "Men from Barnsley or Leeds"

 

Question 8

Design a report to list all students who are resident with children. List students in order of children from most children through to least children.

Save your report as "Resident Students with Children"

 

Question 9

Design a report to give a total count of only those students who live in Barnsley.

Group your report into Men and Women

You should list only INIT, SNAME, GENDER and HTOWN.

Make sure that you include a line at the bottom of your report that reads:

The total number of Students from Barnsley = ??

Format this line to be at 14 point and in bold.

Save your report as "Total Number of Students from Barnsley".

 

Question 10

Create a report that lists all students and subdivides the report into Resident and non-resident students.

You should give the total number of students in each category and also give the total number of students in the entire report. List all fields in any way you see fit.

Save your report as "Res/Non Res Students".