BCA Chapter 10

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

A value used in a paremeter query

A select query that retrieves data based on criteria typed by the user when the query is run

A wildcard character that matches any one character or no character at all

A select query with criteria that matches a range of values

Two tables in a relational database with corresponding fields

Used to form a validation rule or specify criteria in a range query. Operations include <,>,<=,>=, and <>

A database object that retrives data that matches specified criteria

A datasheet of related records

A query that modifies records based on criteria

Checks entries against specified values for a field

A character used in criteria that matches any one or more characters. Wildcard characters include * and ?.