PITS : All Chapters

Edit Answers
12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849
Across
  1. 2. Macro action to open a form
  2. 8. A pattern that controls how data must be entered
  3. 9. Arranging data in ascending or descending order
  4. 11. Conditions used to filter query results
  5. 13. A single piece of data in a table
  6. 17. Workspace to build macro actions
  7. 18. View used to add and edit table records
  8. 19. Additional details required for macro actions
  9. 20. A field that links to a primary key in another table
  10. 22. View to check layout before printing a report
  11. 25. Macro action to open a report
  12. 28. Additional pages connected to the main switchboard
  13. 29. A custom menu form for navigating a database
  14. 32. The default switchboard that opens on startup
  15. 33. A preset value automatically entered in a field
  16. 35. Macro action to open a table
  17. 37. An output of data arranged for printing
  18. 39. The area used to arrange fields in a query
  19. 40. The kind of data a field can hold
  20. 43. A collection of records arranged in rows and columns
  21. 44. A graphical interface used to enter and view data
  22. 47. Field that displays a list of predefined values
  23. 48. Tool used to create switchboards
  24. 49. A question asked about data in a database
Down
  1. 1. A unique identifier for each record
  2. 3. Association between fields across tables
  3. 4. A stored set of actions for automating tasks
  4. 5. Tool that guides creation of formatted reports
  5. 6. Symbols used to compare values in criteria
  6. 7. Tool to build queries using guided steps
  7. 9. A file that organizes data in rows and columns
  8. 10. A report created without predefined formatting
  9. 12. Macro action to run a query
  10. 14. Returns values based on a true or false test
  11. 15. View used to edit field names and data types
  12. 16. Area where all database objects are listed
  13. 21. Tool that helps create forms based on tables or queries
  14. 23. Command used to display tables when creating relationships
  15. 24. Combination of fields operators and functions
  16. 26. A structured collection of data
  17. 27. Field created from a formula or expression
  18. 30. Both conditions must be true in a query
  19. 31. The maximum number of characters allowed in a field
  20. 34. At least one condition must be true in a query
  21. 36. Ensuring data follows correct formats
  22. 38. The alternate display name for a field
  23. 39. A dynamic subset of records produced by a query
  24. 41. Query that asks for user input when run
  25. 42. A complete row of related fields
  26. 45. Button on a switchboard that runs an action
  27. 46. Combining records with common values in reports