CSE1IS Information Systems
Tutorial - Week 10
Report Design

La Trobe University, Bendigo campus Department of Computer Science and Computer Engineering
 

MS-Access provides a variety of report design features. Reports can be based on Tables or Queries. In these exercises you will use the report wizard to generate some basic reports and then use the report design window to customise them.

Before beginning you will need to modify one of your existing queries, FullTutorialListQRY.

Use of the Report Wizard

The following table summarises the reports you will generate. From the database window, select:
Reports → New → Report Wizard

Make four reports based on data in the table or query according to the following. Select your own layouts - try different layouts for the different reports.

Query/Table to
base report on		 Grouping Sorting Report Name
Student (table) None Surname
Given name		 StudentRPT
FullStudentResultQRY
(query)		 Student id Assessment number StudentResultRPT
Student (table) Tutorial Number Student id TutorialByIdRPT
FullTutorialListQRY
(query that combines student, tutorial and tutor tables)		 Tutorial number
Tutor’s name		 Student surname
Student given name		 TutorialRPT

Customising the Report design

For each of the reports created (above), access the report design window (highlight report name and select Design).

Some suggestions:
delete the default labels (field names form the tables) and replace them with more meaningful text.

re-size and re-arrange the various components of the report (for example page headers/footers, report headers/footers)

See whether you can produce a report of tutorial groups similar to that shown on the next page.

Note: the tute_room field may not display just one field at a time so you may need to change this. To do so, go to the report design option and highlight the tute_room large box under the tute_no header and click the right-mouse button. Choose Change to text box. This should allow only one field to display in the report rather than all of them. You may have to resize the Detail band to reduce all the blank space.

Example of Design Screen for Report 4:

MS-Access report design view for a tutorial list for each tutor

This should produce a report like that pictured below

Report entitled Tutorial Lists by Tutor. The report lists tutorial number, tutorial time and room followed by the surname, given name and ID for students in that particular tutorial. The tutorials are listed for each tutor for which the tutor name and office is listed. The tutor details form the report section break.

Valid XHTML 1.0 Transitional