Which of the following criterion is NOT written using the proper syntax?
Answer: C) NO VALUE
In Microsoft Access, criteria must follow the correct expression syntax.
- A. "Harls" – Correct syntax for an exact text value. Text criteria are enclosed in quotation marks.
- B. <500 – Correct syntax for finding numeric values less than 500.
- C. NO VALUE – Incorrect syntax. To search for records where a field contains no value (Null), use Is Null.
- D. Between #1/1/2000# And #12/31/2000# – Correct syntax for selecting dates within the specified range. Date values are enclosed in # symbols.
Microsoft Access मा Query Criteria लेख्दा निश्चित Syntax पालना गर्नुपर्छ।
- A. "Harls" – सही। Text Value लाई Double Quotation Marks भित्र राखिन्छ।
- B. <500 – सही। 500 भन्दा कम Numeric Value खोज्न प्रयोग हुन्छ।
- C. NO VALUE – गलत। कुनै Field मा Value नभएका Records खोज्न Is Null प्रयोग गर्नुपर्छ।
- D. Between #1/1/2000# And #12/31/2000# – सही। निश्चित Date Range भित्रका Records खोज्न प्रयोग हुन्छ।
Exam Tip: Blank/Null Field खोज्ने सही Criteria = Is Null.
त्यसैले सही उत्तर C. NO VALUE हो।