Data type- In Access, a field property that determines what type of data the field can contain.
Export- The process of copying data from an Access table or query to another database or to another type of file, such as Exel worksheet.
Field Name- The name by which Access recognizes a data field.
Field Property- A specific attribute of an Access data field, such as name, caption, field size, or input mask.
Import- The process of copying data from another source, such as a database or spreadsheet, into an open Access database.
Input Mask- In Access, a field property that determines display format and limits the type of data that can be entered.
Junction Table- In Access, a table that provides a link between two tables that have a many-to-many relationship.
Link- The connection between a source file and a destination file, or between two tables.
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.
Many-to-many Relationship- In Access, a relationship between two tablesin which each table can have many related records in the other table.
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).
One-to-one Relationship- In Access, a relationship between two tables in which each table has only one related record in the other table.
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.
Primary Key- In Access, one or more fields in a tablewhose values uniquely identify each record.
Primary Table- In Access, the table on the "one" side of a one-to-manyrelationship.
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.
Related Table- In Access, the table on the "many"side of a one-to-many relationship.
Relationship- In Access, the association between two tables that share a field with matching values.
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.
Export- The process of copying data from an Access table or query to another database or to another type of file, such as Exel worksheet.
Field Name- The name by which Access recognizes a data field.
Field Property- A specific attribute of an Access data field, such as name, caption, field size, or input mask.
Import- The process of copying data from another source, such as a database or spreadsheet, into an open Access database.
Input Mask- In Access, a field property that determines display format and limits the type of data that can be entered.
Junction Table- In Access, a table that provides a link between two tables that have a many-to-many relationship.
Link- The connection between a source file and a destination file, or between two tables.
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.
Many-to-many Relationship- In Access, a relationship between two tablesin which each table can have many related records in the other table.
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).
One-to-one Relationship- In Access, a relationship between two tables in which each table has only one related record in the other table.
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.
Primary Key- In Access, one or more fields in a tablewhose values uniquely identify each record.
Primary Table- In Access, the table on the "one" side of a one-to-manyrelationship.
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.
Related Table- In Access, the table on the "many"side of a one-to-many relationship.
Relationship- In Access, the association between two tables that share a field with matching values.
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.
No comments:
Post a Comment