the Case

It was a cold winter night when everyone was gathered in the Salentine Gym to watch the basketball game. The bleachers were packed and the smell of popcorn filled the air. Everyone was excited that our team had made it to the finals and it was a home game. The first half went great we were leading by 10 points when the players went to the locker room. Third quarter did not go so well we were down by 12 points as we moved into the fourth quarter. We scored 6 points right off and it looked like we had gotten our momentum back when all of sudden the lights went out. The audience all groaned at once, the game had gotten so exciting again and this had to happen. The announcer said please stay in your seats it seems that someone turned out the gym lights we will have them back on in a minute. The lights came back on and everyone clapped and the game continued with our team winning by only one point. Wow what a night. But Who Done It, who shut out the lights. You being the local official were called in as soon as lights came on to start your investigation.

Upon arrival at the gym you began interviewing people who were near the light switch to the gym and this is what you learned.

 

Mrs. Jones said, "I saw someone by the light switch that was tall."

 

Little Freddie agreed, “I saw someone tall and they had Curly hair.”

 

Angela said, “I saw someone too, they were wearing glasses.”

 

Mr. Smith said, “I believe I saw someone over there that was thin.”

 

Mark said, “I saw someone that had black hair.”

 

After talking to a few more people you found that the same description was being given so you headed back to your office to enter the description in you Trouble Maker Database. But, in order to do this you needed to create a query that will pull out the most likely trouble maker. Follow the steps below to create your query.

  1. Create a query using all the fields using all fields available from your table. 

     

  2. Modify the query design using information from the clues given in the conversation above. 

     

  3. Run the query to determine "Who Done It!"

     

  4. Create a blank Word document with appropriate heading information.  Indicate "Who Done It" from the results of your query.

     

  5. The trouble maker was brought in for questioning and admitted to standing by the light switch, but...

The trouble maker you thought did it admitted to being by the light switch, so case closed, right?  No, I am afraid not.  New evidence has been presented to you.  The switch the original trouble maker was by does not work.  New evidence states the person who pulled the real switch had long red hair, they were of average height, are heavy set, and they did not wear glasses.  Now you have to enter the new criteria for the trouble maker and see who really did it.

 

Using the same Word document from above, indicate "Who Done It" by the name of the trouble maker below your original response.  Format this document an attractive manner clearly indicating that these are the results of your Who Done It database project.  Feel free to add clip art, change the font and size of text, and add a header or footer.  Save this Word document as your last name followed by Who Done It (i.e. - Jansen Who Done It).  Upload this file to Edmodo.  (Note:  Keep this document to one page please.)

Click here to continue with your next Access database assignment.