icon link
A small icon that links to another document. Used in a document instead of embedding or linking
The part of an expression that refers to an object's value or property. Depending on where and how you are using the expression, the identifier may need parts.
[Price]+[Shipping]  uses the simple identifiers [Price] and [Shipping] to refer to a field in the current table.
  Scores.AssignmentID > 67 uses the full identifier for the AssignmentID field that is in the Scores table.
  Reports![Grades]![StudentName].Visible is the full identifier for the Visible property of the control StudentName that is in the report named Grades.
IIf function
The Immediate IF function is an conditional function, providing two different values, depending on whether an expression is True or False.
Syntax: IIf(expr, truepart, falsepart)
where expr is an expression that can be said to be either True or False, truepart is the value you want to see when the expression is true, falsepart is what you want to see when the expression is false.
Both the truepart and falsepart are evaluated. Be careful that they won't generate an error, like trying to divide by zero.
   IIf([Balance] > 0, "You owe "& [Balance], "Paid")
Image control
A control on a form or report that contains an image. This is different from inserting an image as an OLE object in an unbound OLE frame.
Bringing data or objects into a database from outside the database.
A feature of a database that puts the key fields in a table into order. Sorting and filtering can be much faster using an index, rather than having to work with the original table and all its other data.
Input Mask Property
A field in a table has this property. An Input Mask controls what you see as you enter and edit data in the field. It is a different property from the Format property, which controls how values are display after they are saved.
Examples and syntax