Unit E Flashcards
validation rule
field property that prevents unreasonable data entries for a field
table design view
access window where all characteristics of a atable, such as field names and field properties, are defiones
row source
lookup property that determines where the lookup field gets its list of values
limit to list
determines whether you can enter a new value into a field
attachment field
field that allows you to store external files as a word document, powerpoint presenttaion, excel workbook, or jpeg image
input mask
field property that provides a visual guide as you enter data
primary key field
field that holds unique information for each record in the table
lookup properties
field properties that allow you to supply a drop down list of values for a field
multivalued field
filed that allows yout o make more than one choice from a drop-down list
which of the following problems most clearly indicates that you need to redesign your database
there is duplicated data in several records of a table
which of the following is not done in the table design view
creating file attachments
what is the purpose of enforcing referencial integrity
to prevent orphan records from being created
to create a many to many relationship between 2 tables, you must create
two primary key fields in each table
the linking field in the mnay table is called the
foreign key field
if the primary key field in the one table is an autonumber data type the linking fdield in the many table will have which data type
number