Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

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
Q

Give an example of a one to one relationship.

A

One customer has only one address and one address has only one customer.

26
Q

Give an example of a one to many relationship.

A

One customer has many orders. But those orders only have one customer.

27
Q

What is another way of referring to the “one” table?

A

The parent table

28
Q

What is another way of referring to the “many” table?

A

The child table

29
Q

Why do you want to eliminate one to one relationships?

A

They are redundant. The information can be combined into one table.

30
Q

What kind of relationships should your app contain?

A

One to manys

31
Q

How do you resolve many to many relationships?

A

With a third table

32
Q

What is an ERD?

A

Entity Relationship Diagram

33
Q

What is step one in creating an Entity Relationship Diagram?

A

Develop a list of entities (or tables) that belong in the data model.

34
Q

What is step two in creating an entity Relationship Diagram?

A

Determine and diagram the relationships between those entities.

35
Q

In any given relationship, there is always a …. ?

A

Parent table and child table

36
Q

What is the Data Modeling exercise?

A

This determines what tables you are going to need in your database as well as the relationships between the tables.

37
Q

After completing the Data Modeling exercise, what is the next step?

A

Filemaker needs to know how to link the tables together. You have to choose fields in each table to link to another table.

38
Q

What are the fields in tables that connect tables?

A

key fields

39
Q

What are the two types of key fields?

A

Primary key

Foreign key

40
Q

Where is the primary key defined?

A

in the parent table (one)

41
Q

Where is the foreign key defined?

A

in the child table (many)

42
Q

What is the relational model?

A

Data is broken down into small pieces which are connected to each other in relationships.

43
Q

Why break down data into small pieces?

A

One time entry makes data more accurate and allows connection to other small pieces of data.

44
Q

How do you begin making a database?

A

Plan the information you want to store in the database. This is called relational modeling.

45
Q

What is a group of data?

A

An entity which becomes a table in the database.

46
Q

What are pieces of data that describe an entity?

A

Attributes which becomes fields in your database.

47
Q

Describe the process of relational modeling.

A

Observe collections of data, break collections into smaller groups and reassemble in logical ways.

48
Q

Using tables, give an example of a one to one relationship

A

Customer names and addresses. Customers will usually have only one address. Rather than separate fields, they should be combined into the customer table.

49
Q

Using tables, give an example of a one to many relationship.

A

Can one customer have many orders? Yes

Can one order have many customers? No

50
Q

Using tables, give an example of a many to many relationship.

A

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
Q

What relationships are ideal for databases?

A

one to many relationships

Eliminate one to one and many to many.

52
Q

How do you eliminate a many to many relationship?

A

Add a third table called a Join Table.

53
Q

In the database planning stage, how do you identify relationship types?

A

Make an Entity Relationship Diagram.

54
Q

What is step one in creating an Entity Relationship Diagram?

A

Create a list of entities (or tables) or tables.

55
Q

What is step two in creating an Entity Relationship Diagram?

A

Determine and diagram the relationship between those entities.

56
Q

What is the third step in creating an ERD?

A

Review the ERD for correctness and consistency..

57
Q

In making an ERD, what kinds of words are significant to look for?

A

nouns

Filemaker Pro 16 (2 decks)

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