Case-Based Critical Thinking Questions Case 3-1 Mrs

Case-Based Critical Thinking Questions Case 3-1 Mrs. Godwin's high school Environmental Science class has collected historical weather data for the months of January, February, and March for three cities.  The data has been entered into a database.  Mrs. Godwin has asked the students to answer the following questions using the Access database.
What was the highest recorded wind speed?
Which city had the highest temperature and what was the highest temperature?

Figure Case 3-1-1

Figure Case 3-1-2
Using the datasheet in Figure 3-1-1, which is the quickest method to help students determine the highest wind speed from the recorded data?

A) create a query that includes the fields: City and Wind mph
B) sort the Wind mph field in Datasheet view using the largest to smallest AutoFilter option
C) use the Ascending sort option from the Sort & Filter group on the Ribbon to sort the City field
D) create a query that includes all fields in the table and sort the Wind mph field