| A | B |
|---|
| Maintaining the database | Definition: To add, change, and delete records in database tables to keep them current and accurate. |
| restructure the database | Definition: Part of database maintenance that involves adding new fields to a table, changing the characteristics of existing fields, and removing existing fields, as well as creating validation rules and referential integrity. |
| split form | Definition: In Access, a form split into two panes; the upper pane lets you display the fields of one record in any arrangement and the lower pane maintains a datasheet view of the first few records. |
| searching | Definition: To look for records that satisfy some criteria. |
| filter | Definition: To specify a set of restrictions to only display specific database records, online images, or files. |
| common filters | Definition: Access-provided filters that allow you to filter for specific values or for a range of values. |
| structure | Definition: The tables, fields, and field characteristics that comprise a database. |
| lookup field | Definition: A field that has lookup properties, which are used to create a drop-down list of values to populate the field. |
| multivalued fields | Definition: Fields that can contain more than one value. |
| calculated field | Definition: In Access, a field used in queries that are not contained in a database, but can be computed from fields that are. |
| computed field | Definition: A field used in a query that is not contained in a database, but can be computed from fields that are. |
| action query | Definition: A query that adds, deletes, or changes data in a table. |
| update query | Definition: An action query that updates the values in a field. |
| delete query | Definition: An action query that deletes selected records from one or more tables. |
| append query | Definition: An action query that adds selected records to an existing table. |
| make-table query | Definition: A query that lets you add query results to a new table, which can be in the current database or another database. |
| validation rules | Definition: In Access, rules that a user must follow when entering data to ensure valid data. |
| validation text | Definition: In Access, a field property that determines what message appears if a user attempts to make a field entry that does not pass the validation rule for that field. |
| required field | Definition: In Access, a field in which a user must enter data; neglecting to do so generates an error. |
| range of values | Definition: In Access, a validation rule that specifies that the values in a field must fall within a certain range. |
| default value | Definition: A value that Access will display on the screen in a particular field before the user begins adding a record. |
| legal values | Definition: A validation rule that specifies that the values in a field must come from a certain collection of possibilities. |
| allowable values | Definition: A validation rule specifying that field values must come from a certain collection of possibilities. |
| referential integrity | Definition: A set of rules that Access enforces to maintain consistency between related tables when you update data in a database, and prevents the creation of orphan records. |
| foreign key | Definition: A primary key field from one table that you include as a field in a second table to form a relationship between the two tables. |
| one-to-many relationship | Definition: In Access, the relationship between two tables in a database in which a common field links the tables together; the linking field is called the primary key field in the “one” table of the relationship and the foreign key field in the “many” table of the relationship. |
| subdatasheet | Definition: A datasheet that is nested within another datasheet to show related records; the subdatasheet shows the records on the “many” side of a one-to-many relationship. |
