. . . Database development featuring Microsoft Access

Call 512-202-7121

For Free Consultation

 

Database Glossary Terms Beginning With The Letter A

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

A

account number

The number assigned to an account.

action query

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.

aggregate query

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.

alias

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.

amortization

A chart of payments over time; often a loan repayment schedule.

append query

An action query that will insert records (rows of data) into a table.

application fields

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.

archive table

A table used to store records that are no longer needed for the day-to-day operation of an application.

argument(s)

A value that a function or method or other type of action can receive when called.

attachment data

Various forms of data or file types that an attachment data type field can accept.

attributes

A characteristic or quality of something being described or represented.

autoindex

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.

autojoin

A feature of Access that will automatically join two tables together in the query designer. By default the option is enabled.