Assignment 8
Home Up

ASCII table

Using what you have read and Access with the advanced filter method to answer the following questions. In a word processor copy the questions below and type the expression used to obtain the answer. Clearly label and include your names and hand in.

  1. Who are all the players from Montreal?
  2. Who are all the goalies?
  3. Who are all the defence men from Montreal?
  4. Who was born before 1970?
  5. Who was born between 1970 and 1976?
  6. Are there any defence men born before 1970? If there are, who are they?
  7. I remember the last four digits of a player, but can not, for the life of me remember their name. Can you help me? The digits are 8951
  8. Anybody west of Montreal has a Postal Code the begins with a letter after "G", produce a list of players that live west of Montreal.
  9. What players were born in 1971 in Quebec City?
  10. . Which players were born in September?
  11. . Which players have a last name ending in with a letter after "O" that are goalies?
  12. . Which players have a "ky" somewhere in their last name?
  13. . Which players are defence men but not from Montreal?
  14. . Which players are younger than you?