If you need a calculation in an unbound control, you can create a custom _____. A. string B. expression C. relationship D. syntax

string
expression
relationship
syntax

The correct answer is: B. expression

An expression is a combination of operators and operands that evaluates to a value. In Access, expressions can be used to perform calculations, filter data, and control the flow of a macro or VBA procedure.

A string is a sequence of characters that is enclosed in quotation marks. Strings can be used to store text, such as names, addresses, or product descriptions.

A relationship is a connection between two tables in a database. Relationships are used to ensure that the data in the tables is consistent.

Syntax is the set of rules that govern how a language is written. In Access, syntax is used to create queries, forms, reports, and macros.

Here are some examples of expressions that can be used in Access:

  • =SUM(A1:A10) – This expression adds the values in cells A1 through A10.
  • =IF(A1>B1, “Yes”, “No”) – This expression returns “Yes” if the value in cell A1 is greater than the value in cell B1, and “No” otherwise.
  • =DATE(2023, 2, 25) – This expression returns the date February 25, 2023.

I hope this helps!