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;
18 Cards in this Set
- Front
- Back
|
a field that uniquely identifies each record in a table.
|
primary key
|
|
|
the name of a field
|
field name
|
|
|
what kind of data can be stored in a field
|
data type
|
|
|
attributes
|
field properties
|
|
|
a field property that allows only a specific number type of characters to be entered into a field and formats them correctly
|
input mask
|
|
|
the process of coppying data from another source, such as a database or spreadsheet, into an open access database.
|
import
|
|
|
the connection between a source file and a destination file.
|
link
|
|
|
an association you can create between common fields in two tables.
|
relationship
|
|
|
one supplier for many products
|
one-to-many relationship
|
|
|
the "one" table in a one-to-many relationship.
|
primary table
|
|
|
the "many" table in a on-to-many relationship.
|
related table
|
|
|
each record has many related records in the other tables.
|
many-to-many relationship
|
|
|
the go-between for two tables.
|
junction table
|
|
|
each record in one table is related to one single record in the other table.
|
one-to-one
|
|
|
a set of rules access uses to maintain the accuracy of a database as time passes and changes are made to the data.
|
referetial integrity
|
|
|
all the related records in the "many" table.
|
orphan
|
|
|
view and manipulate records in the related table without actually opening the related tables.
|
subdata sheets
|
|
|
displays a list of values from which you or other database users can "look-up".
|
lookup field
|
