Access - Lesson 2 Key Terms

1. Data Type: In Access, a field property that determines what type of data the field can contain( for example: Number, Text, Date/Time, or yes/No).

2. Export: the process of copying data from an Access table or query to another database ot to another type of file, suach as an Excel worksheet.

3. Field Name: The name by which Access recognizes a data field.

4. Field Property: A specific attribute of an Access data field, such as name, caption, field size, or input mask.

5. Import: The process of copying data from another source, such as a database or spreadsheet, into an open Access database.

6. Input Mask: In Access, a field property that determines display format and limits the type of data that can be entered.

7. Junction Table: In Access, a table that provides a link between two tables that have a many-to-many relationship.

8. Link: The connection between a source file and a destination file, or between two tables.

9. Lookup Field: In Access, a field that looks up a list of values in another table or in a static list, and presents the list of values for data entry selection.

10. Many-to-many Relationship: In Access, a relationship between two tablesin which each table can have many related records in the other table.

11. One-to-many Relationship: In Access, a relationship between two tables in which one table (the primary table) can have many related records in the other table (the related table).

12. One-to-one Relationship: In Access, a relationship between two tables in which each table has only one related record in the other table.

13. Orphan: In Access, records in the related table (on the "many" side of a relationship)that are left unrelated if their related record in the primary table (on the "one" side of the relationshiop)is deleted or charged so that the relationship its broken.

14. Primary Key: In Access, one or more fields in a tablewhose values uniquely identify each record.

15. Primary Table: In Access, the table on the "one" side of a one-to-manyrelationship.

16. Referential Integrity: A system of rules that Access uses to ensure that relationships between records in related tables are valid, and that you dont accidentally delete or change related data.

17. Related Table: In Access, the table on the "many"side of a one-to-many relationship.

18. Relationship: In Access, the association between two tables that share a field with matching values.

19. Subbdatasheet: In Access, a datasheet that is nested within another datasheet and contains records related to the records in the datasheet in which it is nested.