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;
19 Cards in this Set
- Front
- Back
|
kinds of data that can be stored in a field
|
data type
|
|
|
process of copying data from an access table to another database or file type
|
export
|
|
|
table that provides a link between two tables that have a many-to-many relationship
|
junction table
|
|
|
name by which access recognizes a data field
|
field name
|
|
|
connection between a source file and a destination file or between to tables
|
link
|
|
|
attribute of an access data field such as name caption field size or input mask
|
field property
|
|
|
a field that looks up a list of values in other tables or in a static list
|
lookup field
|
|
|
process of copying data from another source into an access database
|
import
|
|
|
relationship between two tables in which each table can have many related records in the other table
|
many-to-many relationship
|
|
|
a field property that determines display format and limits the type of data that can be entered
|
input mask
|
|
|
one object for many other objects
|
one to many relationship
|
|
|
each reord in a table is related to a single record in another table
|
one to one relationship
|
|
|
the "many" table in a one to many relationship
|
related table
|
|
|
records in a related table that are left unrelated
|
orphan
|
|
|
an association you can create between common fieds in two tables
|
relationship
|
|
|
one or more fields in a tables whose values uniquely identify each record
|
primary key
|
|
|
datasheet that is nested in another datasheet which it is also related to
|
subdatasheet
|
|
|
the "one" table of a one to many relationship
|
primary table
|
|
|
system of rules used by by access to ensure that relationships between records in related tables are valid
|
referential integrity
|
