- Shuffle
Toggle OnToggle Off
- Alphabetize
Toggle OnToggle Off
- Front First
Toggle OnToggle Off
- Both Sides
Toggle OnToggle Off
Front
How to study your flashcards.
Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key
Up/Down arrow keys: Flip the card between the front and back.down keyup key
H key: Show hint (3rd side).h key
PLAY BUTTON
PLAY BUTTON
19 Cards in this Set
- Front
- Back
|
a field that uniquely identifies each recod in a table.
|
primary key
|
|
is just that the name of a field.
|
field name
|
|
you are talling Accass what kinds of data can be stored in the field, such as a number, a data, or alphanumeric data.
|
data type
|
|
the lower pane of the table design window.
|
field properties
|
|
a field property that allows only a specific number and type of characters to be entered into a field, and automatically formats those characters correctly.
|
input mask
|
|
existing data into an Access database from most list-or database-type files, such as Excel, Lotus 1-2-3, Paradox,dBase,other Access database,SqL, FoxPro, and others.
|
import
|
|
the data in any Access table to a file outside the database.
|
export
|
|
to the file where the current data are maintained.
|
link
|
|
is an association you can create between common fileds in the tables.
|
relationship
|
|
Supplies-to-Products relationship.
|
one-to-many relationship
|
|
one table in a one-to-many relationship.
|
Primary Table
|
|
the "many" table.
|
Related Table
|
|
in which each record in each table has many related records in the other table.
|
Many-to-many relationship
|
|
is careated as the go-between for the tables.
|
junction table
|
|
the least type of relationship.
|
one-to relationship
|
|
is a set of rules Access uses to maintain the accuracy of a database as time passes and changes are made to the data.
|
Referential integrity
|
|
Access will not allow you to delete a record in the "one" table.because that would orphan all the related records in the "many" table.
|
orphan
|
|
to view and manipulate records in the related (the "many table) without actually opening the related table.
|
subdatasheets
|
|
displays a list of values from which you or other database users can choose, or "look up" data, instead of typing a value which,in addition to ensuring data accuracy, also saves time.
|
Lookup Field
|
