Filemaker Pro 9 (40) Flashcards
- p. 280. TAB CONTROLS. How do you create a TAB?
Click on TAB CONTROL TOOL and then draw a TAB PANEL (a SQUARE OR RECTANGLE). Name the TAB, add other tabs if you’d like, and click ok.
- p 286. REPORTS AND SUMMARY FIELDS. FM is not only fantastic at showing you information, it also excels at:
helping you see what it all means.
- Reports show lists of records, but show only the details. To get focused information, you need;
SUMMARY FIELDS.
- SUMMARY FIELDS aren’t associated with RECORDS like other field types, instead, they:
GATHER UP AND PROCESS DATA FROM SEVERAL RECORDS.
- How do you create a SUMMARY FIELD?
FILE–>
MANAGE–>
DATABASE:
FIELDS TAB, new field, and choose SUMMARY as the FIELD’S TYPE, and click Create.
- What is the next step in creating a SUMMARY FIELD?
The OPTIONS FOR SUMMARY FIELD dialog box will open, and you choose one of the radio button options given.
- What are the Radio Buttons available in the OPTIONS FOR SUMMARY FIELD?
a. Total of
b. Average of
c. Count of
d. Minimum
e. Maximum
f. Standard Deviation of
g. Fraction of total
- When you choose COUNT OF radio button option in the OPTIONS FOR SUMMARY FIELD, how does FM count, say, number of people in the database?
COUNT OF will give you a list of FIELDS to choose, and you choose one that has a VALUE IN EVERY FIELD, such as FIRST NAME.
- A SUMMARY FIELD is ALWAYS based on some other field in the database. If you choose COUNT OF and select the FIRST NAME field to be counted, but a few records don’t have first names, then:
FM will skip all those records and they won’t be counted, so be sure and select a field that ALWAYS has a value.
- In the OPTIONS FOR SUMMARY FIELD, the AVAILABLE FIELDS on which the SUMMARY is performed may be grayed out. Why?
If you’re doing an AVERAGE OF, text or picture fields make no sense, so they would be grayed out.
