Microsoft Access

Edit Answers
12345678910111213141516171819202122232425
Across
  1. 2. Numerical or other information represented in a form suitable for processing by computer
  2. 5. A field, used on a form or report in an Access database, that either displays a list of values retrieved from a table or query, or stores a static set of values.
  3. 6. The text that displays in the column header when a table is in Datasheet view
  4. 7. An association that is established between common fields (columns) in two tables. A relationship can be one-to-one, one-to-many, or many-to-many.
  5. 8. Microsoft's relational database program
  6. 10. A property that defines valid input values for a field or record in a table, or for a control on a form. Access displays the message specified in the ValidationText property when the rule is violated.
  7. 13. A question about the data stored in your tables, or a request to perform an action on the data. A query can bring together data from multiple tables to serve as the source of data for a form or report.
  8. 15. The maximum number of characters that can be typed in a field
  9. 16. To copy data from a text file, spreadsheet file, or database table into an Access table.
  10. 17. A structured presentation of information organized in vertical columns (records) and horizontal rows (fields)
  11. 18. The actual data that one enters into a database
  12. 20. The operation performed when data in a database changes
  13. 21. One or more table fields (columns) that refer to the primary key field or fields in another table. A foreign key indicates how the tables are related.
  14. 22. a sophisticated computer program that stores data in related tables
  15. 23. The text used to describe data that should be put in a field
  16. 24. The view in which the structure of a table or query can be viewed and manipulated.
  17. 25. A set of criteria applied to data in order to display a subset of the data or to sort the data. In Access, you can use filtering techniques, such as Filter By Selection and Filter By Form, to filter data.
Down
  1. 1. A view that displays data from a table, form, query, view, or stored procedure in a row-and-column format. In Datasheet view, you can edit fields, add and delete data, and search for data.
  2. 3. An Access database object on which you place controls for taking actions or for entering, displaying, and editing data in fields.
  3. 4. Data from a table, form, query, view, or stored procedure that is displayed in a row-and-column format.
  4. 9. An Access database object that that you can print containing information that is formatted and organized according to your specifications. Examples of these are sales summaries, phone lists, and mailing labels.
  5. 11. The operation performed when a data row is removed from a table in a database
  6. 12. Rules that you follow to preserve the defined relationships between tables when you add, update, or delete records.
  7. 14. An individual item of the information that is the same type across all records.
  8. 16. 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.
  9. 19. One or more fields that determine the uniqueness of each record in a database.