Filemaker Pro 9 02

Question 1

1. p 43. What is a VIEW?

Answer 1

VIEWS are the possible ways to look at a database. There are three:
FORM VIEW
LIST VIEW
TABLE VIEW

Question 2

2. How do you find a RECORD by OMITTING?

Answer 2

Use the OMIT checkbox

Question 3

3. After you do a FIND, and you want to extend the find with other records without losing the original found set, what do you do?

Answer 3

Choose FIND again, then choose EXTEND FOUND SET.

Question 4

4. When doing a FIND, what is the CRITERIA?

Answer 4

It is the FIELD in your request.

Question 5

5. p 49. When you do a FIND, and you use, say, “FOR” in your criteria, FM will only find:

Answer 5

the words that have “FOR” in THE BEGINNING; it won’t find de-FOR-med, or be-FOR-e, but WILL find FOR-ty and FOR-ego.

Question 6

6. How do you find be-FOR-e by using the criteria “FOR”?

Answer 6

you use a WILDCARD (*), as in: *for

Question 7

7. What if you want the CRITERIA to show a MAXIMUM or a MINIMUM, such as all the names that come before John (alphabetically speaking)?

Answer 7

the criteria should be <, or ≤,≥, and = in your criteria for other results.

Question 8

8. When do you use “=” in a search?

Answer 8

When you want an exact match, such as SMITH: “=smith”.

Using the symbol = will NOT bring up Smithsonian, Smithey, etc.