Filemaker Pro 9 (106) Flashcards

1
Q

This set entered on 7-26-14
7.26.14.7

  1. FUNCTIONS. What is a FUNCTION?
A

It is simply a PREDETERMINED FORMULA

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q
  1. What is a FUNCTION that would find an average in a given field?
A

Average ( Line Item::Quantity )

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q
  1. What are the names of the components of the Function:

Average ( Line Item::Quantity )

A

The word “Average” is the FUNCTION’S NAME. “Line Item::Quantity” is a reference to a RELATED field.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q
  1. What is a PARAMETER?
A

They tell the FUNCTION how to perform its specific calculation. For example, in the function:

Average ( Line Item::Quantity )

the “Line Item::Quantity” is the PARAMETER. This Function has only ONE parameter, but many Functions have two or more.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q
  1. How are PARAMETERS presented in a Function?
A

Parameters are ALWAYS enclosed in PARENTHESIS.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q
  1. When there’s more than one Parameter, THEY’RE SEPARATED BY:
A

A SEMICOLON, as in this Function:

Date ( Month ; Day ; Year )

How well did you know this?
1
Not at all
2
3
4
5
Perfectly