PHS badge

PHS CyberSchool

Computer Studies SG 

Modified 27 April 2005

Election database - Queries Test (30 marks)

Copy the database electionaccesstest.mdb from the shared drive / CSSG or copy and unzip the file electionaccesstest.zip,  to your own folder.  Rename the file YourInitialsElectionAccessTest.mdb.  Write the answers neatly on foolscap paper.  Perform the following queries based on the fictitious data.  Save each query by number and subject of the query.  Do the work in the order given.  When you have completed the last question copy the file to the directory Pupils / Projects / Term 1 or send as am email attachment to your teacher.

A.  Simple queries (10 marks)

  1. How many people live in the suburb of  Kensington? (1)
  2. How many people have the surname of Smith?  (1)
  3. How many people with the surname of Nel live in Kensington?  (1)
  4. In which suburb(s) do people with the surname Adams live?  (1)
  5. How many people have the letters/word GORDON anywhere in their first names?  (1)
  6. How many people with the surname of Parker live in Kensington or Windermere?  (1)
  7. What is the most common surname?  How many of them are there?  (2)
  8. How many suburbs are found in this ward? Which suburb has the highest number of voters?   (2)

B.  ID Numbers are known to begin with the numbers of the year in which a person is born (6 marks)

  1. How many people were born in 1954?   (1)
  2. How many people were born in January 1947?  (1)
  3. How many people were born before or in 1940?  (1)
  4. How many people were born in or after 1980?  (1)
  5. How many people were born in 1930-something and live in Goodwood Park?  (1)
  6. How many people were born in 1950 or live in Maitland?  (1)

C.  Number of children (6 marks)

  1. How many people have 2 children or less?   (1)
  2. What is the total number of children born to people who live in Townsend Estate?  (1)
  3. How many suburbs have no children born to it / in it?  (1)
  4. What is the maximum number of children born to a person in Kensington?  (1)
  5. Which suburb has the most number of children?   How many of them are there in this suburb?  (2)

D.  Calculation expressions (2 marks)

  1. Join the First Names to the Surnames of all the records.   (The expression to obtain GAVIN LESLIEZUNGU is worth 1 mark.  The expression to obtain GAVIN LESLIE ZUNGU is worth 2 marks.)  Write out the expression clearly.  Save the query for marking.  

E.  Not sure of heading (6 marks)

  1. Based on the table Ward XYZ create a new table called Augustus showing all the details of the people whose surname is Augustus.  Save the query for marking. (2) 
  2. Delete from the table Ward XYZ the records of the people who live in Acacia Park.  Save the query for marking.  (2)  
  3. In the table Ward XYZ in the Surname field change all names that begin with AB to AAA.  Save the query for marking.  (2)

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