Music+Lessons++-+Access

A school has 2 databases. One keeps a record of pupils at the school, the other is a database of thedifferent instruments which are taught in the school.

You should use the database Music Students to help you answer the questions below.

You should attempt to answer each question by: a) Stating which search you will perform e.g. Name = Smith AND Age > 40 b) Performing the search and noting the answers


 * 1) Which pupil in 2T1 is learning a stringed instrument?
 * 2) Which pupils in 4R1 play an instrument which is part of the school orchestra?
 * 3) Which instrument does Mr Undsworth teach Nick Fenton?
 * 4) Which instrument does Mr Undsworth teach Sue Burns
 * 5) How many pupils play a wind instrument which is not part of the school orchestra?