Shared Flashcard Set

Details

IT163 Unit 4 Glossary of Terms
Terms for Unit 4- IT163
15
Computer Science
Undergraduate 2
01/20/2011

Additional Computer Science Flashcards

 


 

Cards

Term
Append Query
Definition
adds records from one table to the end of another table
Term
Cascade the Delete
Definition
when Access allows a deletion of a record but also deletes all the related records
Term
Default Value
Definition
the value that Access displays in a particular field before the user begins adding a record
Term
Delete Query
Definition
a query that will delete all the records satisfying the criteria entered in the query
Term
Filter
Definition
to have only the records that satisfy a criteria appear
Term
Foreign Key
Definition
a field in one table whose values are required to match the primary key of another table
Term
Index
Definition
is created based on a field or combination of fields
Term
Lookup Field
Definition
allows users to choose from a list of values
Term
One-to-Many
Definition
one record in a table is related to, or matches, many records in a second table
Term
Referential Integrity
Definition
the property that ensures that the value in a foreign key must match that of another table's primary key
Term
Required Field
Definition
a field in which the user MUST enter data
Term
Single Field Index
Definition
an index whose key is in a single field
Term
Subdatasheet
Definition
a datasheet that appears below the plus sign of a related table
Term
Update Query
Definition
allows you to make changes to all records satisfying some criterion
Term
Validation Rules
Definition
rules that a user must follow when entering data
Supporting users have an ad free experience!