Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
12 Cards in this Set
- Front
- Back
|
when you store the same data in more than one place
|
data redundancy
|
|
|
determines what field values you can enter for a field
|
data type
|
|
|
access forces you to enter a value for the primary key in every record
|
entity integrity
|
|
|
the process of relating tables
|
join
|
|
|
two or more fields functioning as a primary key
|
composite key
|
|
|
text file is one in which fields of data are separated by a character such as a comma or a tab
|
delimited
|
|
|
you cannot give this to the primary key field
|
null value
|
|
|
what you do to a property when you select a value for it
|
set
|
|
|
data type that limits field values to on and off, for example
|
yes/no object
|
|
|
data type that consists of integers with values controlled by Access
|
AutoNumber
|
|
|
data type that allows field values created in other programs as objects
|
OLE Objects
|
|
|
data type that creates a field that lets you find a value in another table
|
Lookup Wizard
|
