Mrs. Rich said, "The thief must have worn glasses. I found a bottle of lens cleaner near the safe. The maid stated, "I found some brown hair on the windowsill where the thief entered. Does that help?" The gardener "Could it have been that short person I saw running toward the gate?" . "I'm sure it was a woman," piped in Jeeves the butler. "And I noticed she was short like the gardener said." The cook added, "I'll never forget those cold green eyes! She was very scary." With that, you took these clues back to the office where you entered opened your database that contained the lists of suspects. With your skills of running quarries, list the thief below: Creating Queries: To create a query, complete the following steps: Open your Mystery Database table. Drop down the new object menu and choose new query. Choose design view, then click OK. Choose the field you wish to find information about (you can double click the fields and it will automatically fill in the field for you). In the following queries you will choose glasses, because the first clue was that the thief wore glasses. After selecting the field, you will need to determine the criteria. Click in the criteria cell and put a check mark in the checkbox to indicate that yes, the thief wore glasses. The second clue was that the thief had brown hair. Click in the second field box and select hair. In the criteria cell, type the word brown. The third clue was that thief was short. In the third field box, choose height, and then typed short into the criteria cell. The forth clue given was that the thief was a woman. Click in the fourth criteria cell and type woman. The last clue was that the had green eyes. Select eyes as the field, then type green in the criteria cell. Your query dialog box should look like the one below: To run the query, click the run query button on the formatting toolbar. You should have only one suspect listed. Write the answer to mystery 1 on a separate piece of paper to turn into your teacher. You now are the expert on running quarries. Solve the second mystery below using the same Mystery Database and include your answer on the same piece of paper that you used for the mystery above.
Mrs. Rich said, "The thief must have worn glasses. I found a bottle of lens cleaner near the safe. The maid stated, "I found some brown hair on the windowsill where the thief entered. Does that help?" The gardener "Could it have been that short person I saw running toward the gate?" . "I'm sure it was a woman," piped in Jeeves the butler. "And I noticed she was short like the gardener said." The cook added, "I'll never forget those cold green eyes! She was very scary." With that, you took these clues back to the office where you entered opened your database that contained the lists of suspects. With your skills of running quarries, list the thief below: Creating Queries: To create a query, complete the following steps: Open your Mystery Database table. Drop down the new object menu and choose new query. Choose design view, then click OK. Choose the field you wish to find information about (you can double click the fields and it will automatically fill in the field for you). In the following queries you will choose glasses, because the first clue was that the thief wore glasses. After selecting the field, you will need to determine the criteria. Click in the criteria cell and put a check mark in the checkbox to indicate that yes, the thief wore glasses. The second clue was that the thief had brown hair. Click in the second field box and select hair. In the criteria cell, type the word brown. The third clue was that thief was short. In the third field box, choose height, and then typed short into the criteria cell. The forth clue given was that the thief was a woman. Click in the fourth criteria cell and type woman. The last clue was that the had green eyes. Select eyes as the field, then type green in the criteria cell. Your query dialog box should look like the one below: To run the query, click the run query button on the formatting toolbar. You should have only one suspect listed. Write the answer to mystery 1 on a separate piece of paper to turn into your teacher. You now are the expert on running quarries. Solve the second mystery below using the same Mystery Database and include your answer on the same piece of paper that you used for the mystery above.
Solving%20a%20Mystery-database%20creation.docx