Some definitions have been taken or adopted from the Microsoft Access 2002 glossary available online at 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 ...

Get Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.