K201 Access Exam Questions and Correct Verified Answers 2026.

K201 Access Exam Questions and
Correct Verified Answers 2026.
Show today's date - Answer date()



Show Yesterday's date - Answer date() - 1



Show Tomorrow's date - Answer date() + 1



To leave a blank - Answer ""



No value listed - Answer Null or Is Null



Anything but "Bloomington" - Answer Not "Bloomington"



or



<> "Bloomington"



Medium date format - Answer 23-Aug-02



To make characters uppercase - Answer > (Format)



Input mask - Answer Creates a template for the input of data



Requires an uppercase letter (Input mask) - Answer L



Optional Letter (Input Mask) - Answer ?



Optional Number (Input Mask) - Answer 9