Fields and Field properties
- Field Name
- The name of your field should represent the contents
of what is incorporated with the field. Examples
include "Name" and "Final Grade." The name may not
surpass 64 characters and it may also include spaces.
-The whole reason
for a table is because of the fields that can exist
with in it.
- By specifying
the data type of the field, one can combine various
types of data to provide more options when making a
- Properties can
be viewed at any time
- They allow for
modifications to be simplified if so need be
How to Set a Primary Key
- One or more fields whose value
distinctively recognize every record in a table. It
does not allow null values and will always have a
distinct value. It is used to associate a table to
other keys in other tables.
- You donít have to identify a primary
key, but it would be a good idea to do so. If you
don't want to set a primary key, you will be asked if
you would like to create one when saving the table.
Example: If you were to make a table
with social security numbers; You could make the
social security number field the primary key, meaning
that for all the students that have a social security
number and of their numbers. none of them have two
numbers that are the same; You may do as follows:
the social security number field and select the
primary key button
will create your primary key.