Filemaker Pro 9 04 Flashcards

1
Q
  1. Ch 3. p 92.

What is the foundation of a DB?

A

TABLES. Everything else in a db works IN SERVICE OF THE TABLES IN SOME WAY.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q
  1. What extension does FM Pro 9 have?
A

.fp7
It means that people with versions 7 or 8 can use version 9 files, although some of the new features won’t work for them.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q
  1. What is a FIELD TYPE?
A

It determines what kind of information the field holds.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q
  1. What are the different types of fields?
A
text
number
date
time
timestamp
container
calculation & summary
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q
  1. How much info can a TEXT field hold?
A

2 gigs

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q
  1. When should you use a NUMBER field?
A

only when you plan to perform MATH with it. For Zip codes and phone numbers use TEXT fields.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q
  1. A TIME field can serve two purposes. What are they?
A

You can enter a time of day (3:37pm) or a DURATION (27:35:45).

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q
  1. How do you apply a TIME FORMAT to the TIME FIELDS (p 253)?
A

FORMAT–>TIME

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q
  1. When entering TIME VALUES, you always start with:
A

HOURS, i.e., 12 minutes 47 seconds is entered as 00:12:34

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