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 ?.