Term
|
Definition
| a question about the data stored in your tables, or a request to perform an action on the data. It can bring together data from multiple tables to serve as the source of data for a form or report |
|
|
Term
|
Definition
| a format that consists of literal display characters (such as parentheses, periods, and hyphens) and mask characters that specify where data is to be entered as well as what kind of data and how many characters are allowed |
|
|
Term
|
Definition
| an association between two tables in which the primary key value of each record in the primary table corresponds to the value in the matching field or fields of many records in the related table |
|
|
Term
|
Definition
| rules that you follow to preserve the defined relationships between tables when you add, update, or delete records |
|
|
Term
|
Definition
| an operator that is used to compare two values or expressions. For example, <(less than), > (greater than), and = (equal to) |
|
|
Term
|
Definition
| a collection of formats that determines the appearance of the controls and sections in a form or report |
|
|
Term
|
Definition
| allows you to resize objects and cells |
|
|
Term
|
Definition
| a type of database that stores information in the form of logically related two-dimensional tables |
|
|
Term
|
Definition
| an Access database object on which you place controls for taking actions or for entering, displaying, and editing data in fields |
|
|
Term
|
Definition
| an expression that Access compares to query field values to determine whether to include the record that contains each value. For example, = "Chicago" is an expression that Access can compare to values in a text field in a query |
|
|
Term
|
Definition
| when a record in the many-side (child or related) table relationship has no corresponding record in the one-side (parent or primary) table. An example of this may be a Product in the Products table that does not have a Supplier in the Suppliers table, therefore the Product is an orphan record |
|
|
Term
|
Definition
| the primary method for sorting the data |
|
|
Term
|
Definition
| the secondary method for sorting the data |
|
|
Term
|
Definition
| Combine two Boolean values and return a true, false, or null result--also referred to as "Boolean Operators" |
|
|
Term
|
Definition
| aid in the creation of difficult commands in Access |
|
|
Term
|
Definition
| a control used on a form, report, or data access page to display or modify data from a table, query, or SQL statement. The control's Control Source property stores the field name to which the control is bound |
|
|
Term
|
Definition
| a control that is not connected to a field in an underlying table, query, or SQL statement. An unbound control is often used to display informational text or decorative pictures |
|
|
Term
|
Definition
|
|
Term
|
Definition
| a data organization issue that allows the unnecessary duplication of data within your Microsoft Access database |
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
| design view of building a report in Access |
|
|
Term
|
Definition
| the process of one action triggering another action |
|
|
Term
|
Definition
| a set of criteria applied to data in order to display a subset of the data or to sort the data |
|
|
Term
|
Definition
| an Access tool that you can use to create an expression. It includes a list of common expressions that you can select |
|
|
