| |
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.
- Who are all the players from Montreal?
- Who are all the goalies?
- Who are all the defence men from Montreal?
- Who was born before 1970?
- Who was born between 1970 and 1976?
- Are there any defence men born before 1970? If there are, who are they?
- 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
- 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.
- What players were born in 1971 in Quebec City?
- . Which players were born in September?
- . Which players have a last name ending in with a letter after "O" that are
goalies?
- . Which players have a "ky" somewhere in their last name?
- . Which players are defence men but not from Montreal?
- . Which players are younger than you?
|