Filemaker Pro 9 09

Question 1

1. p 113. “STRICT DATA TYPE: TIME OF DAY” tells FM that:

Answer 1

only time values that represent REAL CLOCK TIMES are acceptable. You CANNOT enter a duration such a “36:45:23”

Question 2

2. When would you use “STRICT DATA TYPE: UNIQUE”?

Answer 2

Use it on ID NUMBERS, USER NAMES, or other info that SHOULD IDENTIFY A SINGLE PERSON UNIQUELY.

Question 3

3. When would you use “STRICT DATA TYPE:EXISTING VALUE”?

Answer 3

When the field should contain only values that are already on that field in other records, such as 1957 Ford car models (so that you don’t enter Cadillac DeVille).

Question 4

4. “STRICT DATA TYPE: IN RANGE” lets you specify:

Answer 4

a MINIMUM and a MAXIMUM allowable value

Question 5

5. “IN RANGE” does NOT work for what type of fields?

Answer 5

it works on ALL the STANDARD data types, since they all have a concept of order.

Question 6

6. What does “IN RANGE: ADAM TO JOHNSON” do?

Answer 6

It DOES NOT VALIDATE Schulz or Torres, but accepts Harrison.

Question 7

7. “IN RANGE.” Range validation is most common in:

Answer 7

Number, Date, and Time values. You can require the age to be between 0 and 100, or the birth date to be between 1-1-1900 and 1-1-2007.

Question 8

8. “MAXIMUM NUMBER OF CHARACTERS” prevents you from entering 10 characters when you’ve specified 8 to be the max. How do you specify a MINIMUM number of characters?

Answer 8

You must use a CALCULATION: Length (MyField)>=5,
but you MUST USE the “VALIDATE BY CALCULATION” for this option.
“MY FIELD” is replaced by the name of the field, such as the field named ZIP CODE.