Some definitions have been taken or adopted from the Microsoft Access 2002 glossary available online at http://office.microsoft.com/en-us/ assistance/HA010562951033.aspx.
- action query
A query that copies or changes data. (Compare with select query.)
- aggregate function
A function such as Sum, Count, or Avg used to calculate totals.
- alternate key
A candidate key that is not used as a primary key.
- arithmetic operator
A symbol (such as + or -) that tells you to perform an arithmetic operation.
- artificial primary key
A key created solely for the purpose of serving as a primary key. In Access, artificial primary keys usually have an AutoNumber data type.
A data type usually used as a primary key. By default, each new record in the ...