Which of the following statements are true about an expression used in Microsoft Office Access 2010?
Each correct answer represents a complete solution. Choose all that apply.
A.
It performs a calculation.
B.
It manipulates character or test data.
C.
It defines the actions needed to perform as a result of a defined event.
D.
It is a set of logical or mathematical operators, functions, and constants.
Explanation:
An expression is a set of logical or mathematical operators, functions, constants, and names of field,
control, and property. It evaluates to a single value. An expression performs the following functions:
Manipulate character or test data.
Perform a calculation.
Answer C is incorrect. In Microsoft Office Access 2010, a macro is a database object that defines the
actions that are required for Access to perform as a result of a defined event. It is also used to open
and execute queries, open tables, and print or view reports. A user can add simple conditions in
macros to specify when actions are performed or skipped.