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;
19 Cards in this Set
- Front
- Back
a field property that determines what type of data the field can contain (for example: Numbers, Text, Date/Time, or Yes/No)
|
Data Type
|
|
Copying data from 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 acces data field, such as name, caption, field size, or input mask
|
Field property
|
|
The proccess of copying data from another source, such as a database or spreadsheet, into an open access database
|
Import
|
|
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
|
|
A table that provides a link between two tables that have a many-to-many relationship; the 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; any changes made later to the source file are reflected in the destinaton file. contrasted with embed
|
link
|
|
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
|
Lookup field
|
|
a relationship between two tables in which each table can have many related records in the other table
|
many-to-many relationship
|
|
a relationship between two tables in which only one table can have related records in the other table
|
one-to-many relationship
|
|
a relationship between two tables in which each table has only one related record in the other table
|
one-to-one relationship
|
|
records in a related table that are left unrelated record in the primary table is deleted or changed so that the relationship is broken
|
orphan
|
|
one or more fields in a table whose values uniquely identify each record
|
primary key
|
|
tha table on the one side of a one-to-many relationship
|
primary table
|
|
a system of rules that access uses to ensure that relationships between records in related tables are valid, and that you don't accidentally delet or change related data
|
referential integrity
|
|
the table on the many side of a one-to-many relationship
|
related table
|
|
the association between two tables that share a field with matching values; the matching fields allow the tables to be joined, so that a query can select data from both tables
|
relationship
|
|
a data sheet that is nested within another datasheet and contains records related to the records in the datasheet in which it is nested
|
subdatasheet
|