Case AC 7-1 Ed Brown is the chief financial officer of a medium-sized business distributing geological surveying meters and associated equipment to engineering companies and government agencies. Ed has noticed that the company sales and receipts are not matching properly, and he suspects inadvertent human error in Access database data entry. Which of the following expressions can Ed define as a valid expression meaning the date entered needs to be after June 30, 2014? A) #6/30/2014# B) #6/30/2014# C) 6/30/2014

Question

Case AC 7-1 Ed Brown is the chief financial officer of a medium-sized business distributing geological surveying meters and associated equipment to engineering companies and government agencies. Ed has noticed that the company sales and receipts are not matching properly, and he suspects inadvertent human error in Access database data entry. Which of the following expressions can Ed define as a valid expression meaning the date entered needs to be after June 30, 2014?
A) >#6/30/2014#
B) #6/30/2014#
C) <#6/30/2014#
D) >6/30/2014

Quizplus · Accepted Answer

In Access database, the symbol ">" means greater than and the pound sign "#" is used to enclose date values. Therefore, the expression ">#6/30/2014#" means that the date entered needs to be after June 30, 2014. The other options do not use the correct symbols or do not express the condition correctly.

Case AC 7-1 Ed Brown Is the Chief Financial Officer