Term
|
Definition
| Maintains information about various types of objects (inventory), events (transactions), people (employees), and places (warehouses) |
|
|
Term
|
Definition
| One or more fields (columns) whose values uniquely identify each record in a table. It cannot allow Null values and must always have a unique index. It is used to relate a table to foreign keys in other tables. |
|
|
Term
|
Definition
| One or more table fields (columns) that refer to the primary key field or fields in another table. It indicates how the tables are related. |
|
|
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
| A key that has more than one field |
|
|
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. If the value for that field in a given record is"Chicago", Access includes the record in the query results. |
|
|
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. They are 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 ControlSource 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
| An Access database or Access project file. An Access 2007 database stores database objects and data in an .accdb file, and earlier versions of Access use the .mdb format. A project file does not contain data, and is used to connect to a Microsoft SQL Server database. |
|
|
Term
|
Definition
| Design view of building a report in Access |
|
|
Term
|
Definition
| The process of one action triggering another action. For example, when a cascading update relationship is defined for two or more tables, an update to the primary key in the primary table automatically triggers changes to the foreign table. |
|
|
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. |
|
|
