FileMaker FM0-302 - FileMaker8 Developer Essentials Exam
Which two privileges are needed for a non [Full Access] privilege set to allow the creation and modification of new layouts in a FileMaker Pro 8 database? (Choose two.)
Click the Task button.
Place each specification next to its definition for FileMaker Server 8 Advanced (Windows OS).
Click the Exhibit button.
Given a layout including the Tab Control shown in the exhibit, what are two valid methods to navigate to the Phones tab? (Choose two.) Note: None of the contents of the Phones tab exist anywhere else on the layout.
A number field in FileMaker Pro 8 called AmountPaid is set to auto-enter the following formula:
Case (
AmountPaid > AmountDue;
TextColor (AmountPaid ; RGB (0; 255 ; 0));
AmountPaid > 0 ;
TextColor (AmountPaid ; RGB (255 ; 0 ; 0));
AmountPaid
)
The Do not replace existing value of field (if any) option is unchecked.
Which statement is true?
What is a valid way of adding comments inside a calculation formula in FileMaker Pro 8 database?
While in a FileMaker Pro 8 database on a layout based on the Customer table occurrence, the following script is run:
Show All Records
Go to Record/Request/Page [First]
Loop
If [Customer::Category <> "A"}
Omit Record
Else
Go to Record/Request/Page [Next; Exit after last]
End If
Exit Loop If [Get ( FoundCount )= 0]]
End Loop
After the script stops running, which two statements are true? (Choose two.)
What is the result of the following formula?
Substitute("Abcd"; ["a";"b"];["b";"a"];["c";"d"];["d";"c"])
Given the formula:
Filter ( "Computer Science 201"; "0123456789" )
What is the result?
Given the following formula:
Date (
Month ( Get ( CurrentDate ) ) + 1;
1;
Year ( Get ( CurrentDate ) )
) - 1
What is the result?
A layout showing records from a People table has the Save record changes automatically checkbox disabled in the Layout Setup dialog. Which two actions cause FileMaker Pro 8 to display a dialog asking whether or not you want to save changes to the current record? (Choose two.)
