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;
13 Cards in this Set
- Front
- Back
query
|
a dtabase object that lets you ask the database about the data it contains.
|
|
condition
|
is a way of telling the query which data you are interesting in seeing.
|
|
simple query wizard
|
ask you which data you want to see by letting you select option in dialog box.
|
|
sort
|
sorts files in assending order from a to z.
|
|
filter
|
temporailty displays records in a database based on the condition that you specify.
|
|
filter by selection
|
helps you to use different types of filters to display the data you need.
|
|
filter by form
|
use when you need yp display records that contain one or more values based on values stored in one or more fileds.
|
|
autofilter
|
is a menu that opens when you click the arrow on the right side of a field selectors.
|
|
relationship
|
between two tables must design the tables so that they contain a common field.
|
|
common field
|
field that appears in both tables and have the same data type.
|
|
one-to-many-relationships
|
one record in the first table can match many records in the second table.
|
|
foreign key
|
the common feild in the related tables.
|
|
referential integrity
|
protects the data in the tables to make sure the data isent deleted or changed.
|