Chapter 15 Database Development 2

1234567891011121314151617
Across
  1. 1. A method of controlling the format of data which is being entered into a database
  2. 5. A parameter query that searches using more than one parameter value i.e. on two or more criteria
  3. 6. Ensures that changes made in the linked table are shown in the primary table
  4. 8. Part of a record that stores a single data item. in a table, each field is represented by a column
  5. 11. A specialised language used to create databases and to retrieve and process data in a database
  6. 12. The unique identifier within its table
  7. 13. A small program that is written to perform a repetitive task automatically
  8. 15. A key field which consists of two or more fields
  9. 16. A list of data which can be used (or looked up) to provide all available values for a given data field
  10. 17. Software tool which automates complex tasks for users by providing user prompts and asking questions to complete the task step by step
Down
  1. 2. A query where the user is prompted to enter search criteria each time a query is activated
  2. 3. Field used to indicate the location in a document where data extracted from a database file should be inserted following the completion of a mail merge process
  3. 4. A reference in one table to a primary key in another
  4. 7. A file, like a document, graphic, or video, created by one application that can be inserted into another
  5. 9. Used to search and extract data from the database to find the answer to a question
  6. 10. Used to ensure the user has entered data and has not left a value or field blank
  7. 12. Contains code which facilitates reading and writing to the data within an object
  8. 14. Automatically generates a unique, incrementing numeric value for each new record in a table or other data structure