Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
18 Cards in this Set
- Front
- Back
the process of copying data form an Access table or query to another database or to another type of file, such as an Excel worksheet
|
export
|
|
The name by which Access recognizes a data field
|
field name
|
|
A specific attribute of an Access data fild, such as name, caption, field size, or input mask
|
field property
|
|
The process of copying data form another source, such as a database or spreadsheet, into an open Access database
|
import
|
|
In Access, a field property that determines display format and limits the type of data that can be entered; makes data entry faster and more precise.
|
input mask
|
|
In Access, a table that provides a link between two tables that have a many to many relationship; that junction table has one to many relationship with each of the two tables it links.
|
Junction Table
|
|
The connection between a source file and a destination file, or between two tables; and changes made later to the source file are reflected in the destination file. Contrast with embed.
|
Link
|
|
In Access, a field that looks up a list of values in another tables or in a static list, and presents that list of values for data entry selected.
|
Lookup Field
|
|
In Access, a realtionship between two tables in which each table can have many related records in the other table.
|
Many to many relationship
|
|
In Access, a relationship between two tables in which only one table(the primary one)can have many related records in the other table(the related table)
|
one to many relationship
|
|
In Access, a relationship between two tables in which each table has only one related record in the other table.
|
One to one relationship
|
|
In Access, records in a 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 realtionship) is deleted or changed so that the relationshipis broken.
|
Orphan
|
|
In Access, one or more fields in a table whose values unquiely identify each record.
|
Primary Key
|
|
In Access, the table on the "one" side of a many to one relationship.
|
Primary Table
|
|
A system of rules that Access uses to ensure that relationship between records in related tables are vaild, and that you don't accidentlly deleted or change related data.
|
Referential Integrity
|
|
In Access, that table on that "many" side of a one to many realtionship.
|
Related Table
|
|
In Access, that association between two tables that share a field with matching values; the matching fields allow that tables to be joined, so that a query can select data form both tables.
|
Relationship
|
|
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.
|
Subdatasheet
|