Connor Wants to Display Records for Orders Placed Before January

question 320

Multiple Choice

Connor wants to display records for orders placed before January 1, 2020. Which of the following criteria should he use in the OrderDate field in Query Design view?

• A)<[1/1/2020]
• B)<"1/1/2020"
• C) <1/1/2020
• D)<#1/1/2020#

---

Definitions:

Oxygenated Blood

Blood that is rich in oxygen, typically found in arteries, having been oxygenated in the lungs.

Deoxygenated Blood

Blood that has a reduced oxygen content after circulating through the body and is on its way back to the lungs for reoxygenation.

Arteries

Vessels carrying blood away from the heart.

Veins

Vessels that carry blood to the heart.