Intro to Databases and Tables - Lesson 1

Edit Answers
12345678910111213141516
Across
  1. 4. An Access database object that that you can print containing information that is formatted and organized according to your specifications.
  2. 5. A field data type that you use for objects created in other programs that can be linked or embedded (inserted) in an Access database.
  3. 6. A field, used on a form or report in an Access database, that either displays a list of values retrieved from a table or query, or stores a static set of values.
  4. 8. characteristic of a field that determines what kind of data it can store.
  5. 10. A pane that is used to view or modify the properties of various objects such as tables, queries, fields, forms, reports, data access pages, and controls.
  6. 11. Named piece of information about each person, place, or thing; in an Access table, each field is displayed in a column.
  7. 13. An action or set of actions that you can use to automate tasks.
  8. 15. A database that contains tables, queries, forms, reports, pages, macros, and modules; access projects contains forms, reports, pages, macros, and modules.
  9. 16. In an Access database, a field data type designed for numerical data that will be used in mathematical calculations.
Down
  1. 1. A question about the data stored in your tables, or a request to perform an action on the data. A query can bring together data from multiple tables to serve as the source of data for a form or report.
  2. 2. A collection of data and objects (such as tables, queries, or forms) that is related to a particular topic or purpose.
  3. 3. A field data type that automatically stores a unique number for each record as it is added to a table.
  4. 7. Data from a table, form, query, view, or stored procedure that is displayed in a row-and-column format.
  5. 9. An Access database object on which you place controls for taking actions or for entering, displaying, and editing data in fields.
  6. 12. The "one" side of two related tables in a one-to-many relationship. A primary table should have one of these and each record should be unique.
  7. 14. Collection of details (fields) about an individual person, place, or thing, such as an employee record or a product record.