Maintaining a Database Crossword Puzzle
QUESTIONS LIST: split form : 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 : to look for records that satisfy the criteria, filter : to specify a set of restrictions to only display specific database records, online images, or files, common filters : access-provided filters that allow you to filter for specific values or for a range of values, structure : the tables, fields, and field characteristics that comprise a database, lookup field : a field that has lookup properties, which are used to create a drop-down list of values to populate the field, multivalued fields : fields that contain more than one value, calculated field : in access, a field used in queries that are not contained in a database, but can be computed from fields that are, computed field : a field used in a query that is not contained in a database, but can be computed from fields that are, action query : a query that adds, deletes, or changes data in a table, update query : an action query that updates the values in a field, delete query : an action query that deletes records from one or more tables, append query : an action query that adds selected records to an existing table, validation rules : in access, rules that a user must follow when entering data to ensure valid data, validation text : 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 : in access, a field in which a user must enter data; neglecting to do so generates an error