Database Glossary – A
Useful Terms For Working With Data
Ad hoc Query
See: Query, Ad Hoc.
Address Change Service – ACS
An automated process of the US Postal Service providing change-of-address information to businesses and organizations maintaining computerized database mailing lists.
A single [summary] field’s value, based on results calculated from values found in like fields across an entire set or subset of records; typically counts, sums,
averages, first, last, minimum and maximum.
See also: Field, Summary.
Similar to import; copying all or a subset of records from one table, and adding them to another.
See also: Import.
The lowest level of data granularity.
See also: Granularity.
Describes the value found in each field in a table. Every field or column in a database table represents a single attribute of that table. (An attribute
is what the data in that field represents.
See also: Value.
Takes information from one or more other fields and performs mathematical, date or string operations to provide new information. If necessary, the new information
can simply be displayed as part of a query or report, or can be used to create an entirely new field that is part of the query (or report) but typically not part of
the data table.