The flashcards below were created by user
cstock
on FreezingBlue Flashcards.
-
One to many relationship
The relationship between two tables when there is one and only one record in the primary key table that relates to zero, one, or more records in the record table
-
Parameter
A value used in a paremeter query
-
Parameter Query
A select query that retrieves data based on criteria typed by the user when the query is run
-
Question mark
A wildcard character that matches any one character or no character at all
-
Range query
A select query with criteria that matches a range of values
-
Related
Two tables in a relational database with corresponding fields
-
Relational operations
Used to form a validation rule or specify criteria in a range query. Operations include <,>,<=,>=, and <>
-
Select query
A database object that retrives data that matches specified criteria
-
Subdatasheet
A datasheet of related records
-
Update query
A query that modifies records based on criteria
-
Validation Rule
Checks entries against specified values for a field
-
Wildcard
A character used in criteria that matches any one or more characters. Wildcard characters include * and ?.
|
|