Multiple Choice
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
Correct Answer:

Verified
Correct Answer:
Verified
Q11: The arrangement of records sorted in a
Q21: The AutoFilter sort method works on a(n)_
Q36: Results of a query may be viewed
Q39: Statistical information such as totals and averages
Q40: Access may base queries on one or
Q49: The primary key of a table must
Q51: The Expression Builder dialog box is available
Q64: Which keyboard shortcut selects the first field
Q72: Mrs. Godwin's high school Environmental Science class
Q80: Ja'nice launched an online jewelry business several