Access Module 3 Vocabulary Worksheet

To add, change, and delete records in database tables to keep them current and accurate.
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.
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.
To look for records that satisfy some criteria.
To specify a set of restrictions to only display specific database records, online images, or files.
Access-provided filters that allow you to filter for specific values or for a range of values.
The tables, fields, and field characteristics that comprise a database.
A field that has lookup properties, which are used to create a drop-down list of values to populate the field.
Fields that can contain more than one value.
In Access, a field used in queries that are not contained in a database, but can be computed from fields that are.
A field used in a query that is not contained in a database, but can be computed from fields that are.
A query that adds, deletes, or changes data in a table.
An action query that updates the values in a field.
An action query that deletes selected records from one or more tables.
An action query that adds selected records to an existing table.
A query that lets you add query results to a new table, which can be in the current database or another database.
In Access, rules that a user must follow when entering data to ensure valid data.
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.
In Access, a field in which a user must enter data; neglecting to do so generates an error.
In Access, a validation rule that specifies that the values in a field must fall within a certain range.
A value that Access will display on the screen in a particular field before the user begins adding a record.
A validation rule that specifies that the values in a field must come from a certain collection of possibilities.
A validation rule specifying that field values must come from a certain collection of possibilities.
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.
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.
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.