Filemaker Pro 9 (104) Flashcards

1
Q

This set entered on 7-26-14
7.26.14.5

  1. What calc would you use to get the volume of a cube?
A

Length * Width * Height

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q
  1. What operator works to hook two TEXT values together?
A

The CONCATENATION OPERATOR (&). It hooks together two text values, as in:

Length & “ Inches”

If the LENGTH FIELD contains 36, the result of this calc is: 36 Inches

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q
  1. What are the COMPARISON operators?
A

You often need to compare two values, for example, you may need to add an additional shipping charge of the total weight if an order is more than 20 pounds. ALL COMPARISON OPERATORS RESULT IN A BOOLEAN VALUE.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q
  1. What are examples of COMPARISON OPERATORS?
A

=, >, etc.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q
  1. What are the LOGICAL OPERATORS?
A

They evaluate values and come up with a BOOLEAN (YES/NO) result. Unlike the other operators, most of the LOGICAL OPERATORS are recognizable words.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q
  1. What does the AND (Logical Operator) tell you?
A

it tells you if both values are YES.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q
  1. What does this calc evaluate to:
    Length > 3
    and Height > 5 ?
A

It EVALUATES to Yes if the Length is more than 3 AND the Height is more than 5.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q
  1. The OR operator tells you if:
A

EITHER VALUE IS YES.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q
  1. What does this calc evaluate to:
    Length > 3 or
    Height > 5 ?
A

It evaluates to Yes if the length is more than 3 OR the Height is more than 5.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q
  1. The last LOGICAL OPERATOR, Not, stands alone: it works only on one value, NOT TWO. What would this calc evaluate to:
    Not Length > 3 ?
A

It would evaluate to Yes if the length is NOT more than 3. It simply reverses the BOOLEAN value that comes after it.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q
  1. What is the. ˆ (Exponentiation) Logical Operator?
A

It lets you calculate exponents, as in

Pi * Radius ˆ 2.

This calculation squares the value IN THE RADIUS FIELD.

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