Literal Constants

A literal constant is a specific value such as number, date or text string that does not change.

Numbers

Numerical constants.

Dates

Date constants are enclosed between two hash signs #01/07/2014#.
You can but be aware that these dates ignore the regional settings and are always interpreted in US date format (mm/dd/yyyy).

Strings

String constants are enclosed between double speech marks.
To include a double speech mark inside a text string you need to prefix it with another double speech mark.