Amy would like to find all records that were delivered before January 1, 2011. Her database has a field that tracks when the items were delivered. Amy should _____.

Responses

sort the records in ascending order by item number
sort the records in ascending order by item number

conduct a query and set the criteria to =January 1, 2011
conduct a query and set the criteria to =January 1, 2011

conduct a query and set the criteria as <January 1, 2011
conduct a query and set the criteria as

scroll through the records until she sees January 1, 2011
scroll through the records until she sees January 1, 2011

1 answer

Amy should conduct a query and set the criteria as <January 1, 2011. This will allow her to specifically find all records that were delivered before that date.