Module 4.1-4.2 Flashcards
All new tables have this?
A default list and a default form
For tables that extend another table, the fields on the default list and form depend on what?
The base table’s fields
Where do you go to add a field to a table?
Studio
Steps to adding a field to a table?
Insert a new row which adds a new column
Provide a column label (field name) and type
Capitalize only the first letter of the first word in the label
How do you define a field’s data type?
Double click in the cell
Click the magnifying glass to bring up a list of field classes
Click the green check mark
What are the 5 common field data types?
Date/time
Decimal
Reference
String
True/face
A field data type which features a day and time of day, which can be selected by a calendar widget?
Date/ time
A field data type that features a number with up to two decimal places , (ex: 12.34)
Decimal
A field data type that features a query that displays records from another table?
Reference
A field data type that features a character string?
String
A field data type that features a Boolean field represented by a checkbox?
True/false
What type of data field type should you usually avoids?
Free form unless it’s explicitly necessary
What shouldn’t you use string fields for?
-Dates
-Fields that reference people by name
-Reference objects
When should you use string fields?
When consistent or specially formatted data is not required
What field types should you use to limit options?
Choice lists and reference fields
You should only display fields for data you need (t/f)
True
Why should you choose a field type carefully?
Changing the field type can result in data loss
Before creating a new field, determine if a new field is necessary. If you are extending an existing table, what should you do first?
Consider using or repurposing an existing field
Configuring the label on a field (of an extended table) changes the label only for the current table and not __________?
The parent table
Changing the label on a field of an extended table should be done in caution, why?
The change is only made to the label and not the column name which can cause confusion
Can you combine two fields in one?
Yes it’s called a decision field
How can user-defined fields be deleted from a table?
By clicking the red x button that appears to the left of the column field
These fields cannot be deleted?
Inherited
Are table records deleted when a field is deleted?
No