Access Lesson 16

1234567891011121314151617181920212223242526272829303132333435363738394041
Across
  1. 2. A record whose matching record in either the primary or related table has been deleted. (AC 99)
  2. 8. relationship The type of database relationship that exists between two tables when one record in the first table matches zero, one, or many records in the second table, and when one record in the second table matches at most one record in the first table. (AC 76)
  3. 11. The portion of the Query window in Design view in which you specify the fields and record selection criteria for the query you are creating. (AC 116)
  4. 12. database management system A software program that lets you create databases and then manipulate data in them. (AC 6)
  5. 14. The condition that exists when a primary key has been specified for a table, whereby Access forces you to enter a value for the primary key field in every record in the table. (AC 68)
  6. 15. relational database management system A software program in which data is organized as a collection of tables, and relationships between tables are formed through a common field. (AC 6)
  7. 16. A statement containing a combination of database fields, constants, and operators that you define in a query to perform a calculation. (AC 156)
  8. 21. “one” table in a one-to-many relationship. (AC 77)
  9. 24. 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. (AC 5)
  10. 26. An Access feature, available by clicking the arrow to the right of a field name in Datasheet view for a table or query, that enables you to quickly sort and display the field’s values in various ways. (AC 132)
  11. 27. In a query, an operator that asks Access to compare the value in a database field to the condition value and to select all the records for which the relationship is true. (AC 140)
  12. 31. An Access data type that automatically assigns a unique number to a record. (AC 13)
  13. 32. A primary key that consists of two or more fields. (AC 55)
  14. 33. A type of query in which the value in the specified field must match the condition exactly in order for the record to be included in the query results. (AC 141)
  15. 36. The mode in which you can insert or delete characters in a field value based on the location of the insertion point. (AC 118)
  16. 37. The Access view in which you can make design changes to a form or report while it is displaying data so that you can immediately see the effects of changing the design. (AC 34)
  17. 38. A complete set of field values for a specific person, place, object, event, or idea. (AC 4)
  18. 39. To relate tables using a common field. (AC 98)
  19. 40. In a form based on two related tables, the form that contains data from the related table. (AC 200)
Down
  1. 1. A field that appears in more than one table, allowing you to connect the records in the separate tables. (AC 4)
  2. 3. The “many” table in a one-to-many relationship. (AC 77)
  3. 4. A collection of related tables stored in the same file. (AC 4)
  4. 5. A criterion, or rule, that determines which records are selected in a query. (AC 140)
  5. 6. The display of a table’s contents in rows and columns, similar to a table or spreadsheet; each row is a separate record in the table, and each column contains the field values for one field in the table. (AC 3)
  6. 7. An Access tool that makes it easy to create an expression by providing boxes for entering the expression, options for displaying and selecting common operators, and one or more lists of expression elements, such as table and field names. (AC 156)
  7. 9. A placeholder you use when you know only part of a search value or when you want the search value to start or end with a specific character or match a certain pattern. (AC 195)
  8. 10. A collection of fields that describes a person, place, object, event, or idea. (AC 4)
  9. 13. sort field The first sort field specified that determines the order of records in an object. (AC 133)
  10. 17. A question you ask about the data stored in a database. In response, Access displays the specific records and fields that answer your question. (AC 24)
  11. 18. The field property that determines what field values you can enter for the field and what other properties the field will have. (AC 13)
  12. 19. A field, or a collection of fields, whose values uniquely identify each record in a database table. (AC 5)
  13. 20. A set of rules that Access enforces to maintain consistency between related tables when you update data in a database. (AC 99)
  14. 22. A set of restrictions you place on the records in an open datasheet or form to temporarily isolate a subset of the records. (AC 136)
  15. 23. The specific value, or content, of a field in a record. (AC 4)
  16. 25. In a query, an operator that allows you to combine two or more conditions. (AC 149)
  17. 27. A field that you create with an expression that displays the results of the expression in a datasheet, form, or report, but does not exist as a field in the database. (AC 156)
  18. 28. The first sort field specified that determines the order of records in an object. (AC 133)
  19. 29. A database program you use to enter, organize, display, and retrieve related information. (AC 1)
  20. 30. The value that results from not entering a value for a field; a null value is not permitted for a primary key. (AC 68)
  21. 34. A process that rearranges the data and objects in a database to decrease its file size, thereby making more space available and enhancing the performance of the database. (AC 42)
  22. 35. A list containing the fields for a table, with the table name at the top and the fields listed in the order in which they appear in the table. (AC 116)
  23. 38. A formatted printout (or screen display) of the contents of one or more tables or queries in a database. (AC 25)
  24. 41. A single characteristic or attribute of a person, place, object, event, or idea. (AC 4)