Database Query Criteria

To find children aged 3 years' old

(a)  

To find all pupils who are in Earn House

(a)  

When a field has Marketing Manager, Marketing Assistant, Finance Manager, Finance Assistant, Human Resources Manager and Human Resources Assistant.

What would you type in to find all staff who work in Human Resources...

(a)  

To find all pupils having a Cheese Salad

(a)  

To find pupils who scored more than 50%

(a)  

To find pupils who are at least 17 years or older

(a)  

To find golfers who had a qualifying score of 68 or less

(a)  

Show sales staff who have made sales of more than £12,000

(a)  

Search to find pupils' who attained a mark of 45% and above and 65% and below

(a)  

To find pupils' who’s attendance is 65% or better and 80% or less

(a)