Brainscape's Knowledge GenomeTM


Top Flashcards (Certified)
All Flashcards

Filemaker Pro 16 > Introduction and Getting Started > Flashcards

Introduction and Getting Started Flashcards

1
Q

Where do you get started with Filemaker Pro

A

The Launch Center

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

How do you find Launch Center?

A

Menu > File > Open

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

Why use Launch Center?

A

It gives you access to all of your files in one place.

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

What is a database?

A

A collection of like information with underlying attributes.

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

Why is storing data in a Filemaker, different than storing it in a spread sheet?

A

Relational file vs. flat file.

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

What is a finished app called in Filemaker?

A

Apps or custom apps

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

What are the layers in Filemaker?

A

Data
Presentation
User

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

What does the A in the right side of the layout toolbar do?

A

It opens the formatting tool bar.

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

What toolbars are available in Filemaker?

A

Status, layout and formatting.

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

How do you make changes in fields or layout of components?

A

Hit “Edit Layout” button.

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

Can you customize your status bar in either Browse or Layout Mode?

A

Yes, see command in Toolbar.

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

When your create a new database in Filemaker, what is it called?

A

An app or custom app

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

How can you get started making a new custom app in Filemaker?

A

Go to Toolbar > choose file > Get Started and choose a starter solution (template)>

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

What are special device specific layouts in starter solutions?

A

You can choose layouts for iMac, iPad or iPhone.

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

Besides Basic Starter Solutions found in Get Started, what other template options are there?

A

Scroll down in Starter Solutions to Advanced Starter Solutions.

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

What is the advantage to Starter Solutions (Templates)?

A

You can get familiar with Filemaker without doing any programming.

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

If you start creating an app from scratch, what is the first thing Filemaker asks you to do?

A

Create a table.

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

What is a table?

A

A table is a container within your database that stores data.

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

What is an entity?

A

An entity is a database term for a single person, place or thing.

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

When do you determine which tables and entities you will need in an app?

A

Before you begin building the app, you need to know what tables you will need and what you will store in each table.

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

How do you determine what tables you will need in an app?

A

By identifying entities.

Look for nouns.

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

What is step one in database design?

A

Determine what tables you will need.

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

What is step two in database design?

A

How will tables be related to each other.

24
Q

What are the three types of ways tables can relate to each other?

A

One to one (rare)
One to many/many to one
Many to many

25
Give an example of a one to one relationship.
One customer has only one address and one address has only one customer.
26
Give an example of a one to many relationship.
One customer has many orders. But those orders only have one customer.
27
What is another way of referring to the "one" table?
The parent table
28
What is another way of referring to the "many" table?
The child table
29
Why do you want to eliminate one to one relationships?
They are redundant. The information can be combined into one table.
30
What kind of relationships should your app contain?
One to manys
31
How do you resolve many to many relationships?
With a third table
32
What is an ERD?
Entity Relationship Diagram
33
What is step one in creating an Entity Relationship Diagram?
Develop a list of entities (or tables) that belong in the data model.
34
What is step two in creating an entity Relationship Diagram?
Determine and diagram the relationships between those entities.
35
In any given relationship, there is always a .... ?
Parent table and child table
36
What is the Data Modeling exercise?
This determines what tables you are going to need in your database as well as the relationships between the tables.
37
After completing the Data Modeling exercise, what is the next step?
Filemaker needs to know how to link the tables together. You have to choose fields in each table to link to another table.
38
What are the fields in tables that connect tables?
key fields
39
What are the two types of key fields?
Primary key | Foreign key
40
Where is the primary key defined?
in the parent table (one)
41
Where is the foreign key defined?
in the child table (many)
42
What is the relational model?
Data is broken down into small pieces which are connected to each other in relationships.
43
Why break down data into small pieces?
One time entry makes data more accurate and allows connection to other small pieces of data.
44
How do you begin making a database?
Plan the information you want to store in the database. This is called relational modeling.
45
What is a group of data?
An entity which becomes a table in the database.
46
What are pieces of data that describe an entity?
Attributes which becomes fields in your database.
47
Describe the process of relational modeling.
Observe collections of data, break collections into smaller groups and reassemble in logical ways.
48
Using tables, give an example of a one to one relationship
Customer names and addresses. Customers will usually have only one address. Rather than separate fields, they should be combined into the customer table.
49
Using tables, give an example of a one to many relationship.
Can one customer have many orders? Yes | Can one order have many customers? No
50
Using tables, give an example of a many to many relationship.
Consider an Order Table and a Products Table: Can one order have more than one product? Yes Can one product have more than one order?
51
What relationships are ideal for databases?
one to many relationships | Eliminate one to one and many to many.
52
How do you eliminate a many to many relationship?
Add a third table called a Join Table.
53
In the database planning stage, how do you identify relationship types?
Make an Entity Relationship Diagram.
54
What is step one in creating an Entity Relationship Diagram?
Create a list of entities (or tables) or tables.
55
What is step two in creating an Entity Relationship Diagram?
Determine and diagram the relationship between those entities.
56
What is the third step in creating an ERD?
Review the ERD for correctness and consistency..
57
In making an ERD, what kinds of words are significant to look for?
nouns

Filemaker Pro 16 (2 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2025 Bold Learning Solutions. Terms and Conditions