PITS ACCESS

Edit Answers
12345678910111213141516171819202122232425262728293031323334
Across
  1. 5. Utility used to create and edit switchboards
  2. 9. Function used to test a condition and return one of two values
  3. 11. Feature that restricts the type of data entered in a cell
  4. 12. A visual representation of data in Excel
  5. 16. Tool that guides users in creating queries step-by-step
  6. 18. A file containing one or more worksheets
  7. 19. A collection of related data arranged in rows and columns
  8. 21. Tool used to quickly calculate the total of a range of cells
  9. 22. Logical operator where both conditions must be true
  10. 25. Intersection of a row and column in Excel
  11. 26. A combination of fields, operators, and functions used in queries
  12. 28. Unique identifier for each record in a table
  13. 30. Query that asks the user to enter criteria each time it runs
  14. 33. Cell reference that remains constant when copied using dollar signs
  15. 34. Tool used to change cell appearance based on certain criteria
Down
  1. 1. View used to modify the structure of a table or query
  2. 2. A special form used to navigate and manage database actions
  3. 3. A predefined formula in Excel that performs a specific calculation
  4. 4. Multiple IF statements used together for complex conditions
  5. 6. Linking tables through common fields to retrieve related data
  6. 7. View used to enter and edit data in a table
  7. 8. A set of actions used to automate tasks in Access
  8. 10. A graphical interface used to display and enter data in Access
  9. 13. Function used to search for a value vertically in a table
  10. 14. Every Excel formula begins with this symbol
  11. 15. The main toolbar in Excel and Access with tabs and groups
  12. 17. Function that calculates the mean of selected values
  13. 20. A single sheet within an Excel workbook
  14. 23. A question or request for information from a database
  15. 24. A set of mathematical instructions used to perform calculations in Excel
  16. 25. Where you type conditions in a query
  17. 27. A field whose value is generated from an expression or formula
  18. 29. An organized output of data used for printing or sharing
  19. 31. Tool that helps to create reports quickly in Access
  20. 32. Conditions used in a query to filter data