2007 Microsoft® Office System Step by Step, Second Edition

Glossary

action query

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

active cell

In Excel, the cell that is currently selected and open for editing.

aggregate function

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

append query

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

appointment

In Outlook, a block of time you schedule on your calendar that has a defined start time and end time, and to which you do not invite other attendees.

appointment window

In Outlook, the program window displaying the form in which you ...