Filemaker Pro 9 (100)

Question 1

1. This set entered on 7-26-14.
   7-26-14-1.

How do you supply a calculation with data?

Answer 1

You use your own fields to supply a calculation with data.

Question 2

2. What type of fields can you do calculations on?

Answer 2

In addition to number, you can do calcs on time, date, timestamp, container, and text fields.

Question 3

3. When you create a CALCULATION field in the Manage Database window, the calc field works just like any other field, except you can’t

Answer 3

type data into them. Instead, they use a calculation to determine their own value.

Question 4

4. What else can calcs do?

Answer 4

They can pick apart text and put it back together in different ways

Question 5

5. What can calcs do with time fields?

Answer 5

they can do math on dates, times, and timestamps.

Question 6

6. What can calcs do that summary values can’t?

Answer 6

using calcs, you can use summary values (p. 286) without switching to preview mode.

Question 7

7. You can use a calc field just like any other field: you can

Answer 7

put it in a LAYOUT, use it in FIND MODE, and even use it in OTHER CALC FIELDS.

Question 8

8. You can use calcs with the Records–>Replace Field Contents command so that:

Answer 8

instead of replacing data in every record with the SAME value, the calc can produce a unique value for each record.

Question 9

9. Can you use calcs in scripts?

Answer 9

Scripts use calcs A LOT.