Skip to ContentGo to accessibility pageKeyboard shortcuts menu
OpenStax Logo

Key Terms

action query
query that specifies a particular action, such as creating a new table, deleting a row or rows from a table, updating records, or creating new records
aggregate query
instruction that carries out calculations on a group of records rather than on individual records
append query
query that adds records from one or more tables to the end of another table or tables
arithmetic operator
used to calculate a value from two or more numbers or to change the sign of a number from positive to negative, or vice versa
command control
tool that is used to start an action or a set of actions
comparison operator
used to compare values and return a result that is true, false, or null
control source
area in the property sheet that controls which data is displayed in a particular field, as well as any updates you make to the field
crosstab query
instructions that calculate and restructure data for easier identification of trends or patterns
allows users to view account activity at a glance and quickly find records and reports
data validation
process of ensuring that data is entered correctly into a form by specifying a validation rule for the control in the form
delete query
query that deletes a group of records from one or more tables
Detail section
information that appears once for every row in the record source that is being referenced
external data
data stored outside the current database
form control
part of a form used to enter, edit, or display data; controls can be bound, unbound, or calculated
form property
option that is set in Design View on the property sheet; they control how the form looks, works, and interacts with the rest of the database
Group Footer
area where summary information appears at the end of each group of records
Group Header
area that displays names at the beginning of each new group of records
logical operator
used to combine two Boolean values and return a true, false, or null result; also known as Boolean operators
tool that allows you to automate tasks and add functionality to your forms, reports, and controls
make-table query
query that creates a new table from all or part of the data in one or more existing tables
many-to-many relationship
relationship in which each record in one table can have many related records in another table, and vice versa; this type of relationship, which really consists of two one-to-many relationships, is made possible only by defining a table
message box
used to display alerts, warnings, and other useful information
null criteria
query used to find records that have a null value in a particular field
one-to-many relationship
relationship in which each record in one table has one or more related records in another table, but a record in the second table has only one matching record in the first table
one-to-one relationship
relationship in which each record in one table has at most one related record in another table
parameter query
query that allows you to prompt users whenever a query runs
query criterion
expression that Access compares with query field values to determine whether to include the record that contains each value
range criteria
query used to specify a range of values for a field
select query
query that retrieves data from one or more tables and displays the result in a datasheet
simple criteria
query that specifies an exact value or expression to filter results
SQL query
query created by using a statement in SQL, a programming language designed to manage data stored in relational databases
form that is inserted into another form (the main form)
set of rules by which the words and symbols in an expression are correctly combined
tab order
helps control which section of the form the curser moves to next
update query
query that makes global changes to a group of records in one or more tables
Visual Basic for Applications (VBA)
event-driven programming language and environment from Microsoft that provides a graphical user interface (GUI), which allows programmers to modify code by simply dragging and dropping objects and defining their behavior and appearance
symbol used to represent an unknown character in a search string

This book may not be used in the training of large language models or otherwise be ingested into large language models or generative AI offerings without OpenStax's permission.

Want to cite, share, or modify this book? This book uses the Creative Commons Attribution License and you must attribute OpenStax.

Attribution information
  • If you are redistributing all or part of this book in a print format, then you must include on every physical page the following attribution:
    Access for free at
  • If you are redistributing all or part of this book in a digital format, then you must include on every digital page view the following attribution:
    Access for free at
Citation information

© Jan 3, 2024 OpenStax. Textbook content produced by OpenStax is licensed under a Creative Commons Attribution License . The OpenStax name, OpenStax logo, OpenStax book covers, OpenStax CNX name, and OpenStax CNX logo are not subject to the Creative Commons license and may not be reproduced without the prior and express written consent of Rice University.