Formative Homeroom Database Tasks

Now that you have successfully created your first Database you need modify it by adding some extra features. You will then use it to find out some information.

Create four more Queries and Reports to display them. They should be used for:

1) Searching by the type of Transport that students use to get to school.

2) Searching by the Suburb that students live in.

3) Searching by the Musical Instrument that students play.

4) Searching by student Shoe Size.

Use the Reports you have created to Print as PDF files (see images below). The Reports you should print are:

1)The students who's Transport is by Car.

2) Students who live in the Suburb of Coorparoo.

3) Students who play the Musical Instrument Guitar.

4) All the students who have a Shoe Size of 6.

To Print to PDF - select File/Print and then: