Which kind of field (text, numeric, date, or memo) should you choose if you want to sort the following data? e-mail addresses math marks shoe sizes comments about student effort days when deliveries...

4. Which kind of field (text, numeric, date, or memo) should you choose if you want to sort the following data?
   
   
   1. e-mail addresses
   
   
   2. math marks
   
   
   3. shoe sizes
   
   
   4. comments about student effort
   
   
   5. days when deliveries are expected
   
   
   6. ingredients in cereal
   
   
   
   

B. Practising

6. So far, Anthony has input the following data in a database of all the videos his family owns.
   
   
   

   
   Visual description
   

   
   
   
   
   1. Identify which fields are numeric, text, date, or memo.
   
   
   2. If Anthony sorts his database by “Year released” (from most recent to least recent), which movie will be third?
   
   
   
   


7. The following database lists information about different countries in the world.
   
   
   

   
   Visual description
   

   
   
   
   
   1. How is the data sorted in this database?
   
   
   2. If you sorted this database by population, which country would appear first?
   
   
   3. If Iceland appeared last, which field would you have used to sort?
   
   
   4. If Singapore appeared first, which field would you have used to sort?
   
   
   5. If you sorted this database in increasing order by area, what would be the first five countries?
   
   
   
   


8. As a school fundraiser, students are selling chocolates. This is a sample order form.
   
   
   

   
   Visual description
   

   
   
   
   
   1. How is an order form the same as a record in a database?
   
   
   2. Explain how you could use the information in the order form to create a database for the school.
   
   
   3. Use a computer to create a sample database from the order form.
   
   
   
   


9. Not all databases are computerized. You use a database every time you look up a phone number in the phone book. What databases would you use to find the following information?
   
   
   1. what to order in a restaurant
   
   
   2. how to spell a word
   
   
   3. tomorrow’s weather conditions
   
   
   4. an alternate word for “good”
   
   
   5. the area of a country
   
   
   
   


10. Katya wants to get some information for a project on probability. She goes to the school library and uses the library’s database to find the following information.
    
    Identify which field Katya should use for each situation.
    
    
    1. if she wants the most recent book
    
    
    2. before she looks for the book on the shelves
    
    
    3. when she is trying to find the book on the shelves
    
    
    4. if she wants to find other books by the same author
    
    
    
    

C. Extending

11. Describe how each worker might use a database.
    
    
    1. a family doctor
    
    
    2. a veterinarian
    
    
    3. a police officer
    
    
    4. a real estate agent