2.09 - 2.15 Access

Edit Answers
1234567891011121314151617181920212223
Across
  1. 3. an action query that removes rows matching the criteria that you specify from one or more tables.
  2. 4. primary form in a form/subform combination.
  3. 6. most common type of join; includes rows in the query only when the joined field matches records in both tables.
  4. 7. the section of a report where data in the group is summarized.
  5. 9. the way that records are grouped.
  6. 10. a relationship between identical fields in different tables.
  7. 11. performs a calculation on a set of values and then returns a single value.
  8. 15. an action query that adds the records in a query’s result set to the end of an existing table.
  9. 16. fields that uses an aggregate function to calculate data.
  10. 19. a row inserted at the bottom of a table that provides a menu of functions for each column in the row.
  11. 20. a form/subform combination, also called a master/detail form or a parent/child form.
  12. 23. a collection of records separated visually and displayed with its introductory or summary information.
Down
  1. 1. a form that is inserted into another form.
  2. 2. the section of a report where the name of a grouped field is displayed and printed.
  3. 4. a tool that creates a customizable form that displays multiple records.
  4. 5. a join in which each row from one table is combined with each row from another table.
  5. 8. a column in a query that results from an expression.
  6. 12. a wizard that performs the normalization process by examining a table design and suggesting a way to divide the table for maximum efficiency.
  7. 13. a form that includes a set of navigation tabs that you can click to display forms and reports.
  8. 14. category in the Application Parts gallery that contains a collection of 10 form parts that allows you to add predefined forms to a database.
  9. 17. a field by which data is grouped.
  10. 18. a feature that gives you two views of your data at the same time—in both form view and datasheet view.
  11. 21. a query that calculates a sum, average, count, or other type of total on records and then groups the results by two types of information: one down the left side of the datasheet and the other across the top.
  12. 22. changes the data in its data source or creates a new table.