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;
20 Cards in this Set
- Front
- Back
And operator
|
selects records that match all of two or more conditions in a query
|
|
AutoFilter
|
menu that opens when you click the arrow on the right side of a field selector
|
|
calculated field
|
when a field displays a value that is calculated using other fields in the query
|
|
common field
|
field that appears in both tables, has the same data type, and contains the same values
|
|
condition
|
a way of telling the query which data you are interested in seeing
|
|
expression
|
when fields are used in a calculation
|
|
filter
|
temporarily displays records in a datasheet based on the condition that you specify
|
|
Filter by Form
|
when you need to display records that contain one or more values based on the values stored in one or more fields
|
|
Filter by Selection
|
you select the field value, or part of a field value in a datasheet, and then click the Selection button in the Sort & Filter group on the Home tab
|
|
foreign key
|
the common field in the related table
|
|
multitable query
|
queries that are based on more than one table
|
|
one-to-many relationships
|
one recorded in the first table may match many records in the second table
|
|
Or operator
|
selects records that match at least on of two or more conditions in a query
|
|
Query
|
database objects that lets you ask the database about the data it contains
|
|
referential integrity
|
set of rules to ensure that there are matching values in the common field used to form the relationship
|
|
relationship
|
two tables contain a common field
|
|
Simple Query Wizard
|
asks you what data you want to see by letting you select options in dialog boxes
|
|
sort
|
arranging the data in descending or ascending
|
|
subdatasheet
|
contains the related record in the Orders table(the related table)
|
|
Total row
|
is used to count the number of values in a column
|