A table is displayed showing an alphabetic list of students with the subject codes and titles, year they are in at University and their date of birth. The list was created using fields from both the Students table and the Subjects table. The relationship between the tables is displayed as a line linking the two tables together. Close the Select query window to return to the Database window. Top of document Reports Reports are used to improve the appearance of printed data.
Reports can contain totals and sub-totals.
In the Database window click on the Reports button. Click on Student Report - example. Click Preview to see how the report would print out. The report gives the name of the student, date of birth and year they are in at University. The students are all grouped under the name and code of the course they are taking.