S1
Introduction Course
S2
Introduction course
Computing
Standard Grade
Information Systems
Intermediate II
Information Systems
Higher
Internet
Safety
Business Studies
Dept

4. Complex Searching

Computerised databases can also be searched by using more than one field to find information.

A COMPLEX SEARCH is where MORE than one field is used to search for information.

Play this video
How to Do Complex Searching! Go Full Screen to see in greater detail?

 

Watch the Complex Searching Movie and practice complex searching by answering the following questions in your Progress Grids.

 

 

 

 

 

 

What you have to do!

  1. Using the Flights Database answer the following questions in your progress grids.
    • Make Sure you read each question carefully to see:
      • which fields you have to use in your search.
      • What you are looking for will give you a clue as to which fields you should be using.
1. a. Search for the flights to Spain costing less than £95.
  b. How many flights are there?
  c. Sort the prices into order with the cheapest first.
  d. Write down the flight number of the cheapest flight on the list.
2. How many flights having less than 5 available seats and a ticket price less than £200?
3. How many flights with numbers begriming with GD cost less than £150?
4. How many French flights fly before midday?
5. How many flights to the USA have more than 20 available seats?
6. How many BA flights go to America where the cost is less than £400 (think carefully)?

 

Mark Off Exercise 4 in Your Progress Grids

 

What you should be able to do at the end!

 

Continue to Exercise 5: Adding Records

 


S1 Courses

 

 

 

Home | S1 Topics | S2 Topics
Computing Standard Grade | Info Systems Intermediate II | Info Systems Higher | Internet Safety
Log into Glow | School Website | Contact Us