access ch 2

foreign key

a filed in one table that is also the primary key of another table

autonumber

a number that automatically increments each time a record is added

criteria row

a row in the query design view that determines which records will be selected

cascade delete related fields

when the primary key value is deleted in a primary table, access will automatically delete all foreign key values in a related table

referential integrity

rules in a database that are used to preserve relationships between tables when records are changed

caption property

used to create a more understandable label than a field name label that displays in the top row in the data sheet view in forms and reports

null

used to describe a blank field

comparison operator

uses greater than, less than, etc to limit query results that meet these criteria

one to many relationship

when the primary key value in the primary table can match many of the foreign key values in the related table

simple query wizard

provides a step by step guide to help you through the query design process

AND condition

returns only records that meet all criteria

Or condition

returns records meeting andy of the specified criteria

Cascade update related fields

an option that directs access to automatically update all foreign key allies in a related table when the primary key value is modified in a primary table

field property

characteristic of a filed that determines how it looks and behaves

multiple query

contains two or more tables, enabling you to take advantage of the relationships that have been set in your database

data type

determines the type of data that can be entered and the operations that can be performed on the data

query

enables you to ask questions about the data stored in a database and provides answers to the questions in a datasheet

Wildcard

special character that can represent one or more characters in the criterion of a query

data redundancy

the unnecessary storing of duplicate data in two or more tables