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

3. Simple Searching

Another advantage computerised databases have over manual databases are that they are very easy to use in finding or SEARCHING for information.

 

Searching can also be combined with sorting.

Play this video
How to Do Simple Searches! Go Full Screen to see in greater detail?

 

Watch the Simple Search Movie 3 and practice simple 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 field 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. Search for all flights to Munich.

Write down how many flights are on the list?
2. a. How many BA flights are in the database? Then:
  b. Sort the list by country and write down the flight number of the 4th flight listed. And:
  b. Which country appears most on the list?
3. Search for the flights where the ticket price is greater than £125.

How many flights are on the list?
4. Search for the flights leaving before noon on any date ( think carefully how to do this).

How many flights are there on the list.?
5. a. Search for the flights having more than 40 available seats. Then
  b. How many flights are listed? And
  c. Write down the flight numbers of the flights with the most available seats and also the least number of available seats.

 

Mark Off Exercise 3 in Your Progress Grids

 

 

What you should be able to do at the end!

 

Continue to Exercise 4: Complex Searching

 


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