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;
20 Cards in this Set
- Front
- Back
|
q
|
q
|
|
|
primary key
|
a field that uniquely identifies each record in a table
|
|
|
field name
|
name of field
|
|
|
data type
|
kinds of data can be stored in the field
|
|
|
field properties
|
attributes
|
|
|
input mask
|
a field property that allows only a specific number and type of characters to be entered into a field, and automatically formats those characters correctly
|
|
|
import
|
moving existing data into an access database
|
|
|
link
|
the connection between a source file and a destination file
|
|
|
export
|
file outside the base
|
|
|
relationship
|
association you can create between common fields in two tables
|
|
|
one-to-many relationship
|
one supplier for many products
|
|
|
primary table
|
the "one" table in a one-to-many relationship
|
|
|
many-to-many relationship
|
each record in each table has many related records in the other table
|
|
|
related table
|
"many" table
|
|
|
junction table
|
a table that provides a length between two tables that have many-to-many relationship
|
|
|
one-to-one relationship
|
each record in one table is related to a single record in the other table
|
|
|
referential integrity
|
set of rules access uses to maintain the accuracy of a database as time passes and changes are made to the data
|
|
|
subdatasheets
|
to view and manipulate records in the related table without actually opening the related table
|
|
|
orphan
|
all the related records in the "many" table
|
|
|
lookup field
|
displays a list of values from which you or other database users can choose, or "look up" data, instead of typing a value
|
