access chapter 2 vocabulary
Terms in this set (19)
special character that can represent one or more characters in the criterion of a query.
Characteristic of a field that determines how it looks and behaves.
returns only records that meet all criteria.
a row in the query design view that determines which records will be selected.
determines the type of data that can be entered and the operations that can be performed on that data.
used to create a more understandable label than a field name that displays in the top row in Datasheet view and in forms and reports.
enables you to ask questions about the data stored in a database and provides answers to the questions in a datasheet.
the term access used to describe a blank field.
a number that automatically increments each time a record is added.
the unnecessary storing of duplicate data in two or more tables
when the primary key value in the primary table can match many of foreign key values in the related table.
a field in one table that is also the primary key of another table.
cascade update related fields
an option that directs access to automatically update all foreign key values in a related table when the primary key value is modified in a primary table.
rules in a database that are used to preserve relationships between tables when records are changed.
contains two or more tables, enabling you to take advantage of the relationships that have been set in your database.
returns records meeting any of the specified criteria
simple query wizard
provides a step-by-step guide to help you through the query design process.
cascade delete related records
when the primary key value is deleted in a primary table, access will automatically delete all foreign key values in a related table.
uses greater than (>), less than (<),greater than or equal to, less than or equal to, etc... to limit query results that meet these criteria.