Database Glossary Terms Beginning With The Letter A
The number assigned to an account.
A query that inserts, updates, or deletes data. Specific types of action queries can modify database structures—for example, a make table query will create a table.
A query that returns averages, minimums, maximums, totals, or other values derived from grouped data. Also called a totals query. Several types of queries can used as an aggregate query; including select, append and make table queries.
A name that is given to an expression (i.e., a calculation in a query) or object that is not the actual name of the item. In other words, a nickname.
A chart of payments over time; often a loan repayment schedule.
An action query that will insert records (rows of data) into a table.
Fields that are typically manipulated by an application and not by users of the application. They often contain data that is not directly related to the subject of a table.
A table used to store records that are no longer needed for the day-to-day operation of an application.
A value that a function or method or other type of action can receive when called.
Various forms of data or file types that an attachment data type field can accept.
A characteristic or quality of something being described or represented.
A feature of Access that will create an index for fields that contain specific patterns of text at the end of the field name. By default those suffixes are ID, num, code, and key. You can set your own keywords in the Options dialog.
A feature of Access that will automatically join two tables together in the query designer. By default the option is enabled.