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