O'Reilly logo

Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills by Bob Schneider

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

GLOSSARY

NOTE

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.

AutoNumber

A data type usually used as a primary key. By default, each new record in the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required