Database Query Criteria

To find children aged 3 years' old

To find all pupils who are in Earn House

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...

To find all pupils having a Cheese Salad

To find pupils who scored more than 50%

To find pupils who are at least 17 years or older

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

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

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

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