Reading...
Play button
Play button
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
|
a 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
|
a field that appears in both tables, has the same data type, and conatins the same values
|
|
|
Condition
|
a way of telling the query which data you are interested in seeing
|
|
|
Expression
|
the calculation
|
|
|
Filter
|
temporarily displays records in a datasheet based on the condtion 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 a field value or part of a field value in a datasheet
|
|
|
Foreign Key
|
the common field in the related table
|
|
|
Multitable Query
|
queries that are based on more than one table
|
|
|
One-To-Many Relationship
|
one record in the first table can match many records in the second table
|
|
|
Or Operater
|
selects records that match at least one of two or more conditions in a query
|
|
|
Query
|
a database object 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
|
simpler way to create a query, asks you what data you want to see by letting you select options in dialog boxes
|
|
|
Sort
|
arranges records from A to Z or from smallest to to largest
|
|
|
Subdatasheet
|
contains the related records in the orders table
|
|
|
Total row
|
to count the number of values in a column
|
