data type.
query.
hyperlink.
primary key.
There must be at least two tables.
Many matching records exist in each direction between the tables.
A junction table is used.
You can connect to tables in other databases such as Oracle.
as computer-generated fields.
from an existing single field.
from several existing fields.
All of the above
column entries and attributes must be the same data type.
rows must be in order.
cells contain a single data value.
columns or attributes have a well defined range of values.
Date/Time data types need no delimiters.
Date/Time data types need to be enclosed in single quotes.
Number data types require no delimiters.
Text data types require pound signs.
Format.
Required.
Validation.
Validation Rule.
a Datasheet View is used to display properties.
referenced as an attribute.
changes can be made with a property sheet.
tables forms queries and reports can have properties.
ISBN number for a textbook
Last name
Social Security Number
Student ID
field size.
field type.
Sarbanes-Oxley Act.
validation rule.
Caption
Field Size
Input Mask
Validation Rule