PHS badge

PHS CyberSchool

Computer Studies SG

Modified 09 August 2005

Queries on software

  1. Open Excel. Open the file Software.xls. Save it on your drive with the name SoftwareYourInitals. 
  2. Open Access.   Create a New Blank database and save it on your drive.  Call the database SoftwareYourInitials, e.g. Pam Miller's database would be SoftwarePM. 
  3. Import the file SoftwareYourIntials.xls (File / Get External Data / Import / (Change File of type to Microsoft Excel) and follow the Wizard.  Your imported database should have 29 records. 
  4. Make sure the table in the database SoftwareYourInitials is called SoftwareYourInitials.
  5. Print the table.  Make sure the table fits in ONE page.  Submit the printed table with the query answers to the questions below.
  6. Do the following queries based on the database. Do not bother to save the queries.   Submit the answers on foolscap paper or as a word processed document.  Next to each answer indicate the criteria used to find the answer to the query.  No criteria, no mark.
  1. How many programs are a game?
  2. How many programs are educational?
  3. How many programs are operating system programs?
  4. How many programs cost more than R1000?
  5. How many programs cost more than R500?
  6. How many programs are supplied by WorkGroup?
  7. How many programs are supplied by NetObjects?
  8. How many programs are supplied by www.linuxwarehouse.co.za?
  9. How many programs are supplied by Microsoft?
  10. How many suppliers have za in their web URL?
  11. How many suppliers have macromedia in their web URL?
  12. How many programs cost between R500 and R1000?
  13. How many games cost less than R500?
  14. How many accounting packages cost more than than R1000?
  15. How many programs cost more than R1000 and are supplied by WorkGroup?
  16. Who supplies a web design program which costs less than R1500?
  17. What is the URL of a supplier of a web design program that costs more than R3650 and less than R3700?
  18. What is / are the titles of software that was / were advertised in the 2001/04/01 edition of SA Computer Magazine and cost(s) less than R750?
  19. What is / are the titles of software that was / were advertised after 2001/04/01 in SA Computer Magazine and cost(s) less than R750?
  20. What type of software was advertised after 1 July 2001 in SA Computer Magazine and cost less than R500?

Return to  Computer Studies lesson plan index. This work may be freely copied for non-commercial use only. Copyright © Pam Miller.