SQL for Microsoft Access, 2nd Edition

Appendix C Terms and Definitions

This appendix provides the terms and definitions discussed throughout the book.

Access database — An Access program developed with the Access Jet database engine.

Access project — An Access program that uses an SQL back end exclusively rather than local Jet elements.

Aggregate functions — Used to return a single value based on calculations on values stored in a column.

Alias — An alternate name for a table or column.

ALL — Keyword used to retrieve records from the main query that match all of the records in the subquery.

ALTER TABLE — Keywords used to modify table definitions in an existing table.

ANY — Keyword used to retrieve records from the main query that match any of the records in the subquery.

Arithmetic operators ...