Glossary

Access Database Executable (ACCDE)

A compiled version of a database. Saving a database as an ACCDE file compiles all modules, removes all editable source code, and compacts the destination database.

action query

A type of query that quickly updates information or deletes selected records from a table. See also crosstab query, select query, and parameter query.

aggregate function

A function, such as Sum, Avg, or Count, that groups fields and performs calculations on the field values.

append query

A query that adds, or appends, records from one or more tables to the end of one or more tables.

arithmetic operator

An operator that is used with numerals: + (addition), - (subtraction), * (multiplication), or / (division).

binary file

A file composed of ...

Get Microsoft® Office Access™ 2007 Step by Step 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.