Access Lessons 1-3

3. A database that contains (or can contain) multiple tables with relationships between them. (L1)
5. A specification that describes how a set of records should be sorted, filtered, calculated, or presented. (L1, L7)
8. A field that can contain more than one separate entry per record. (L3)
9. These are records that are not next to (adjacent to) each other.
13. A grid comprised of horizontal rows and vertical columns into which you can enter data. (L1)
14. A spreadsheet-like view of a table in which each record is a row and each field is a column (L1)
15. A view of a table or query’s data, designed for lookup or input of records. (L1, L7)
16. A field that can accept either web addresses or e-mail addresses (L3)
18. A suffix at the end of a file name that indicates its type, such as .accdb. (L2)

1. These are adjacent fields in the table
2. A computer program that includes both the stored database and the tools required to use the database (L1)
4. A collection of variable data about one person or thing. (L1)
6. An organized collection of records. (L1)
7. A placeholder for data that might change. (L1)
10. This appears in a logical (yes/no) field.
11. An item in an Access database, such as a table, query, form, or report. (L1, L2)
12. A printable layout of the data from a table or query. (L1, L7)
17. The field that uniquely identifies each record in a table. (L1, L6)