Carrie entered 10/16/21 as the date in a field with the Date/Time data type and the default format. How does Access format the year in the date after Carrie moves to a new field?
A) as a two-digit year value
B) as a four-digit year value
C) by omitting the year value
D) using the number of digits entered

Question

Quizplus · Accepted Answer

The default format for Date/Time data type in Access is Short Date, which displays the year as a four-digit value. Therefore, the year in the date entered by Carrie will also be displayed as a four-digit value after she moves to a new field.

Carrie Entered 10/16/21 as the Date in a Field with the Date/Time