FileMaker

Question 1

what is a FileMaker file?

Answer 1

a collection of one or more tables with field definition, layouts and scripts

Question 2

what is a master table?

Answer 2

the table that access and displays data from another table.

Question 3

what is a related table?

Answer 3

a table that contains related data you want to access in the master table.

Question 4

what are match/link fields?

Answer 4

a field in the master table and a field in the related table that you can use to find matching records.

Question 5

what is a master record?

Answer 5

a record in the master table for which you want to find matching records in a related table.

Question 6

what is a related record?

Answer 6

a record in the related file whose link field contains a value equal to that of the link field in the master record.

Question 7

what is a portal?

Answer 7

a layout object in the master file that can be used to show related fields.

Question 8

what kind of relationship does a portal display?

Answer 8

a one-to-many relationship.

Question 9

what is a serial number?

Answer 9

an auto-entered value.

Question 10

what are the 4 FileMaker modes?

Answer 10

1. browse
2. find
3. layout
4. preview

Question 11

what is each mode used for?

Answer 11

browse: to enter data
find: used for searches, to execute queries
layout: the backend where you can edit the file
preview: shows printer view.

Question 12

how do you perform a query in SQL?

Answer 12

type the query and perform the find

Question 13

how do you perform a query in FileMaker

Answer 13

1. make a new layout
2. choose, position, label and format the fields
3. enter find mode and type the query
4. perform the find

Question 14

what are the 7 components of a report and how many times is each section printed?

Answer 14

1. header: only once at the top of the page
2. leading grand summary: only once preceding the first leading sub summary
3. leading sub summary: once at the top of each sorted group
4. body: once for each record
5. trailing sub summary: once for each sorted group
6. trailing grand summary: only once after the last trailing sub summary
7. footer: only once at the bottom of the page.

Question 15

how do you perform an AND in FileMaker?

Answer 15

perform a normal find but fill in more than one field

Question 16

how do you perform an OR in FileMaker?

Answer 16

1. enter find more
2. type the first query
3. select new request
4. type the second query
5. perform find

Question 17

how can you do a query with both OR and AND?

Answer 17

by rejigging the query to only include ors

Question 18

what is a report?

Answer 18

a list of records and possibly linked records from linked tables.

Question 19

what is a group?

Answer 19

a set of records based on a sort on some field value.

Question 20

what are 5 benefits/features of scripting?

Answer 20

1. automate a lengthy manual procedure
2. automate an error prone manual procedure
3. customize/entend an application
4. create a different interface
5. hide backend details from the application user.

Question 21

what is a local variable and when is its value erased?

Answer 21

a variable that is useable only in the same script and it’s value is erased when the script ends.

Question 22

how do you define a local variable?

Answer 22

$name

Question 23

what is a global variable and when is its value erased?

Answer 23

a variable that is usable in a calculation or script anywhere in the file and it’s value is not erased until the file is closed.

Question 24

how do you define a global variable?

Answer 24

$$name

Question 25

what is regex?

Answer 25

a way of representing patterns in text

Question 26

when is regex useful?

Answer 26

when trying to find text that matches a pattern and replacing it with something else.