Digital Information Technology Ch. 12 Database Software

Edit Answers
123456789101112131415161718192021
Across
  1. 2. qualifiers on a query
  2. 3. request for data
  3. 5. type of query that displays desired information in rows with totals broken down in columns
  4. 6. contains database information arranged in horizontal rows and verticla columns
  5. 7. field that performs a calculation based on data within the same table; also known as a field on the fly
  6. 8. used to describe a primary key from another table
  7. 9. type of database that contains a collection of joined tables
  8. 11. type of calculated field that provides summary information related to other data within a table
  9. 13. database object used to display only certain data, one record at a time
  10. 16. unique field that will be used by the DBMS to keep track of records
  11. 18. view in Microsoft Access that includes a pane detailing field properties
  12. 19. query that performs an action when it is run
  13. 20. type of query that collects information from multiple tables
  14. 21. view in Microsoft Access that resembles a spreadsheet and allows users to enter data quickly and with minimal formatting
Down
  1. 1. type of database relationship in which a single piece of data is related to several other pieces of data
  2. 4. type of query that can be easily updated with a given search term
  3. 10. (DBMS) software that manipulates data and handles collection, storage, sorting, reporting, and organization of data
  4. 12. structured collection of related information organized for easily locating and retrieving the data
  5. 14. output of the database of specific information requested by the user
  6. 15. column in a database table; contains units or items of information for each record
  7. 17. row in a database table; contains all fields or units of information