table

A collection of data or details about a single subject; the detail are called a field and is shown as is viewable as a column within the table.

temporary table

A table used that stores information during processing; frequently a denormalized table that is also called a working table. For example, data from a query may be used to generate a temporary table combining data from more than one table.

totals query

This is a type of select query that groups data (aka data aggregation) for output that shows totals for a table or multiple table combinations.

transactional database

A relational database management program capable of processing a collection of actions as a single unit, that is referred to as a transaction. A successful transaction processing determines the outcome of the collective affects that are within the transaction proces. Therefore, if any single action fails, the entire transaction will fail. This approach will not save any failed transactions, so they do not become part of the database.

transactional table

A table that stores data relevant to the primary purpose of the database and is also called an "operational" table.

transient field

A field that does not cause any permanent change to the underlying data of a table. Also called a temporary field and is often a computed field

trigger

This is a stored procedure that will execute automatically due to a specific action (event) within the database. Triggers are frequently used in a table as a direct repsonse to data insertion, table updates, or data deletion.