FileMaker 12 Qualification Training (11-15 only) Flashcards
Where can you store container data?
Chapter 11 - Container Fields
a) You can store data loaded into container fields within the database file itself, or “embedded” into the solution
b) You can store data in the original file location, with just the file reference stored in the field.
c) You can store data in a managed folder structure using the managed storage functionality.
What types of files can you store in container fields?
Chapter 11 - Container Fields
You can store any type of file in a container field - for example, audio, video, image, PDF, Excel, and Word files.
In FileMaker Go, how would you record a video then add it to a container field?
Chapter 11 - Container Fields
Tap a container field, then choose the camera option. Swipe the camera switch to video, then type the Record button to record your video. When you stop the recording, tap Use - the video file will be stored in the container field.
In FileMaker Go, describe how you would email a photo directly from a container field.
Chapter 11 - Container Fields
Tap a container field, then choose the Export option. Tap Email to compose an email with the image attached.
Why would you choose managed storage for the container fields in your solution?
Chapter 11 - Container Fields
Managed storage enables people to store large files “in” the solution without actually increasing the size of the solution and affecting performance speed. This option also features encryption of stored data, and streaming media from FileMaker Server.
What is the most efficient way to access Layout mode?
Chapter 12 - Introduction to Layouts
Via the keyboard shortcut Command-L for OS X or Control-L for Windows.
What is the criterion you must specify when creating a new layout, and why is this important?
Chapter 12 - Introduction to Layouts
You must specify the layout’s context. This is important because it determines what data you will be able to see from that layout.
How can you tell if a layout is visible to users in the pop-up menu in the layout bar?
Chapter 12 - Introduction to Layouts
Open the Manage Layouts dialog and find the layout in the list. If there is a check in the box to the right of the layout’s name, it will be visible to users.
What features make the touch themes iOS-friendly?
Chapter 12 - Introduction to Layouts
They have larger fonts and buttons appropriate for the iOS screen size, format, and user gesturing.
Given a one-to-many relationship between Companies and Contacts, what records will appear in a Contacts portal on the Companies layout?
Chapter 13 - Layout Development
Because a portal chooses what records to display based on the relationship between the portal’s table occurrence “TO” and the layout’s TO, the portal will show all Contact records that are related to the current Company record.
What are screen stencils used for?
Chapter 13 - Layout Development
Stencils are placed on a layout to give the developer a guide to follow when designing layouts for different operating systems or devices.
What happens to the objects contained within a layout part when that part is deleted?
Chapter 13 - Layout Development
The objects will be deleted with the layout part. You will be warned before the objects are deleted.
What is the simplest way to add fields and other objects to a layout with standard formats that are not based on the themes?
Chapter 13 - Layout Development
It is easier to duplicate the object with the desired formatting than it is to add a new object (with theme defaults) from the Status Toolbar and modify the formatting.
When is a pop-up menu a good choice for a field control style?
Chapter 14 - Layout Design
A pop-up menu is preferable when the value list has only a few items, because the list shows all the items in the value list.
What is a dynamic value list?
Chapter 14 - Layout Design
A dynamic value list is based on the data that’s entered in a specific field.
When you create layouts for FileMaker Go, what field size
and font size is the smallest that’s recommended?
Chapter 14 - Layout Design
When you add fields to layouts that will be used by FileMaker Go, you should set the field height to 36 pixels, and the font size to 18 point - or bigger - to accommodate a Multi-touch interface.
How does conditional formatting affect data that’s stored in
a database?
Chapter 14 - Layout Design
Conditional formatting doesn’t affect data that’s stored in a database - it affects only how the data appears.
What objects can be included in the tab order?
Chapter 14 - Layout Design
Fields, tab controls, charts, web viewers, and buttons can all be included in the tab order.
What are the two most common types of relationships?
Chapter 15 - Relationships
One-to-many and many-to-many are the most common relationships.
What is the relationship between the following:
a. Actors and Movies
b. Songs and Concerts
c. Aircrafts and Inspections
d. Race and Swimmer
Chapter 15 - Relationships
The relationships are:
a. Many-to-many
b. Many-to-many
c. One-to-many
d. Many-to-many
What field should you create in every table of your FileMaker solution?
Chapter 15 - Relationships
You should always add a primary key field to every table.
How do you resolve a many-to-many relationship?
Chapter 15 - Relationships
Create a join table between the two entities you wish to relate. It will contain foreign keys from both of these tables.
What is the benefit of putting a portal on a layout?
Chapter 15 - Relationships
A portal is used to view and edit multiple related records for a given record; for example, viewing the orders of a customer or viewing the line items related to an order. When the relationship options are set, a portal can also be used to create related records from the context of the parent record.
What four things can you infer from this status toolbar:
Chapter 5 - Viewing and Navigating a Solution
There are 21 total records and three in the found set. The set is unsorted, and the first record is being viewed.
