ACA Access Databases 1-2

Edit Answers
12345678910111213141516171819202122
Across
  1. 3. A term that identifies a field that appears in two separate tables and may be used to connect records in the separate tables.
  2. 7. The best logical data type for a field name PaidDate would be Date/____
  3. 8. Data type that allows both sequential and random numbering, automatically.
  4. 12. When copying and pasting, the copied text goes to this temporary memory space.
  5. 14. Tables, queries, reports, and forms.
  6. 15. View used to make design changes to a form while the form is displaying data.
  7. 17. Compacting a database performs this function and reduces filesize.
  8. 18. Property in table design view that allows the designer to explain the purpose of a field.
  9. 19. If a field will be used to contain long comments or explanation, it is best to use ____ text.
  10. 21. A primary key is used to identify a _____ feature of each record.
  11. 22. This "bar" is used to open and close the Navigation pane.
Down
  1. 1. View used to enter data into a form.
  2. 2. You can import spreadsheet information from ___ to Access only if the field names and column headings match.
  3. 4. This pane holds database objects.
  4. 5. Access database object that asks a question about data and displays specific fields and records to answer the question.
  5. 6. File extension for Access database files.
  6. 9. Each row in an Access table datasheet displays this.
  7. 10. Each column in an Access table datasheet represents this.
  8. 11. View used to enter data into a table.
  9. 13. A Yes/No data type is an example of a __ field type.
  10. 16. Default name for a new table until you name it.
  11. 20. A field in an Access database table that has no value is determined to have a ___ value.