FileMaker 12 Qualification Training (11-15 only) Flashcards

1
Q

Where can you store container data?

Chapter 11 - Container Fields

A

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.

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

What types of files can you store in container fields?

Chapter 11 - Container Fields

A

You can store any type of file in a container field - for example, audio, video, image, PDF, Excel, and Word files.

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

In FileMaker Go, how would you record a video then add it to a container field?

Chapter 11 - Container Fields

A

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.

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

In FileMaker Go, describe how you would email a photo directly from a container field.

Chapter 11 - Container Fields

A

Tap a container field, then choose the Export option. Tap Email to compose an email with the image attached.

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

Why would you choose managed storage for the container fields in your solution?

Chapter 11 - Container Fields

A

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.

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

What is the most efficient way to access Layout mode?

Chapter 12 - Introduction to Layouts

A

Via the keyboard shortcut Command-L for OS X or Control-L for Windows.

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

What is the criterion you must specify when creating a new layout, and why is this important?

Chapter 12 - Introduction to Layouts

A

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 well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

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

A

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.

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

What features make the touch themes iOS-friendly?

Chapter 12 - Introduction to Layouts

A

They have larger fonts and buttons appropriate for the iOS screen size, format, and user gesturing.

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

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

A

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.

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

What are screen stencils used for?

Chapter 13 - Layout Development

A

Stencils are placed on a layout to give the developer a guide to follow when designing layouts for different operating systems or devices.

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

What happens to the objects contained within a layout part when that part is deleted?

Chapter 13 - Layout Development

A

The objects will be deleted with the layout part. You will be warned before the objects are deleted.

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

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

A

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.

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

When is a pop-up menu a good choice for a field control style?

Chapter 14 - Layout Design

A

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.

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

What is a dynamic value list?

Chapter 14 - Layout Design

A

A dynamic value list is based on the data that’s entered in a specific field.

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

When you create layouts for FileMaker Go, what field size
and font size is the smallest that’s recommended?

Chapter 14 - Layout Design

A

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.

17
Q

How does conditional formatting affect data that’s stored in
a database?

Chapter 14 - Layout Design

A

Conditional formatting doesn’t affect data that’s stored in a database - it affects only how the data appears.

18
Q

What objects can be included in the tab order?

Chapter 14 - Layout Design

A

Fields, tab controls, charts, web viewers, and buttons can all be included in the tab order.

19
Q

What are the two most common types of relationships?

Chapter 15 - Relationships

A

One-to-many and many-to-many are the most common relationships.

20
Q

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

A

The relationships are:

a. Many-to-many
b. Many-to-many
c. One-to-many
d. Many-to-many

21
Q

What field should you create in every table of your FileMaker solution?

Chapter 15 - Relationships

A

You should always add a primary key field to every table.

22
Q

How do you resolve a many-to-many relationship?

Chapter 15 - Relationships

A

Create a join table between the two entities you wish to relate. It will contain foreign keys from both of these tables.

23
Q

What is the benefit of putting a portal on a layout?

Chapter 15 - Relationships

A

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.

24
Q

What four things can you infer from this status toolbar:

Chapter 5 - Viewing and Navigating a Solution

A

There are 21 total records and three in the found set. The set is unsorted, and the first record is being viewed.