Applied GCSE ICT – Unit 1 “Tools and Applications”

							Applied GCSE ICT – Unit 1
“Tools and Applications”

      Revision of Queries
    Queries
   What is a Query?
   A database query is used to select required
    records from files in a database
   What is a Simple Query?
   A Simple Query is based on just one field and
    one search value
   What is a Complex Query?
   Complex Queries can be made by combining
    simple queries using the operators AND and
    OR
Query Comparisons
   Equal to (=)
   Finds records where the field value matches
    the search value exactly
    Greater than (>)
   Finds records with a field value greater than
    the search value
   Less than (<)
   Finds records with a field value less than the
    search value
Query Comparisons
   True or Yes
   Finds records with the field value of
    true or yes
   False or No
   Finds records with the field value of
    false or no
Query Comparisons
   Between
   Finds records with a field value between
    and including the two search values
   NOT (<>)
   Finds records with field values that do
    not contain the search value
Loose Limbs Health Club
   They want to know if they need to expand
    the ladies changing rooms (how many female
    members)
   They want to identify members that do not
    pay for a trainer
   They want to start an adult football team and
    need to know all male members born before
    1987 (adults only)
   They want to start an adult football team and
    need to know all male members born before
    1987 and after 1964 (No veterans allowed)
Loose Limbs Health Club
   Mr Goodman (trainer) is ill and they need to
    contact all his trainees to cancel lessons
   They want to invite all members to the Xmas
    party except the Nicholls and Phillips families
    (argument last year in the car park!)
   They want to contact all female members
    that do not take aerobics (special offer to
    join)
North East Fun Run
    Using the Fun Run database find;
   All male runners
   All female veteran runners
   All runners that train on a Wednesday
   All runners aged 31 – 36 inclusive
   All runners that live in Burnsea or run
    for Wasps
   All male runners that paid £3.50 entry
    fee