Filemaker Pro 9 05

Question 1

1. What is a TIMESTAMP?

Answer 1

It is a DATE and TIME field combined. It holds BOTH a date AND a time.

Question 2

2. When should you use a TIMESTAMP?

Answer 2

When you wish to record when an event occurred, or when it will occur.

Question 3

3. What is the benefit of a TIMESTAMP?

Answer 3

it can figure out how much time has passed between two timestamp values (end timestamp - start timestamp).

Question 4

4. What is a CONTAINER field for?

Answer 4

it holds PICTURES, SOUNDS, QUICKTIME MULTIMEDIA files and ORDINARY files.

Question 5

5. How much data can a CONTAINER hold?

Answer 5

2 gigs

Question 6

6. What does a CALCULATION & SUMMARY field hold?

Answer 6

NOTHING. They make up their own values based on settings YOU give them.

Question 7

7. In a CALCULATION field, you can specify a FORMULA that it uses to determine its value, such as:

Answer 7

a person’s age based on their birthdate.

Question 8

8. The value of a SUMMARY field depends on:

Answer 8

The VALUES OF OTHER FIELDS ACROSS SOME SET OF RECORDS. They are NOT associated with a SINGLE RECORD.

Question 9

9. What could you do with a SUMMARY field?

Answer 9

It could show the number of people int the db who are form California, or the total dollar value of all outstanding invoices for a customer.