Asked by CECILIA SIOCO on May 07, 2024
Verified
Which of the following criteria uses the correct syntax for a Date/Time field in a query?
A) %5/7/2021%
B) >5/7/2021<
C) #5/7/2021#
D) "5/7/2021"
Date/Time Field
A type of database field specifically designated to store dates and times, allowing for time-related operations and queries.
- Identify the structure and creation of calculated fields and conditions in queries.
Verified Answer
ES
Erika SaundersMay 12, 2024
Final Answer :
C
Explanation :
In Microsoft Access, Date/Time fields require the pound symbol (#) to indicate that the value is a date. Therefore, choice C is the correct syntax for a Date/Time field in a query. Choice A uses percent symbols, which are used for wildcard characters in Access, and choice B uses greater than and less than symbols, which are not applicable for date values. Choice D uses quotation marks, which are not the correct syntax for date values in Access.
Learning Objectives
- Identify the structure and creation of calculated fields and conditions in queries.
Related questions
What Criterion Would You Use in the LastName Field to ...
Access Adds # Signs Around text criteria in Date/Time Fields
What Criterion Should You Use in the Bedrooms Field to ...
Use >500 as the Criterion for a Number Field in ...
For Group Calculations,Microsoft Access Supports ____ Built-In Statistics ...