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
|
Query
|
is database object that lets you ask the database about the data it contains
|
|
|
Condition
|
a way of telling the query which data you are interested in seeing
|
|
|
Simple Query Wizard
|
Asks what data you want to create by letting you select options in dialog boxes
|
|
|
Sort
|
applied to view values from smallest to largest
|
|
|
Filter
|
temporarily displays records ina datasheet based on the condition you specify
|
|
|
Filter by section
|
when used a field value or part of a field value is selected
|
|
|
Filter by form
|
used when needed to display records that contain one or more values stored in one or more fields
|
|
|
AutoFilter
|
a menu that opens when you click the arrow on the right side of a field selector
|
|
|
Relationship
|
to create a relationshipyou must design the tables so they contain a common field
|
|
|
Common field
|
a field that appears in both tables thas same datatype and contains same values
|
|
|
One-to-many relationship
|
one record in the first table can match many records in the second table
|
|
|
Foreign key
|
the common field in the related table
|
|
|
Referential integrity
|
protects the data in the tables to make sure the data isnt accidentally deleted or changed resulting in inconsistent data
|
|
|
Subdatasheet
|
contains the related records in the orders table
|
|
|
Multitable queries
|
quieries that are based on more than 1 table
|
|
|
And operator
|
selects records that match all of 2 or more conditions in a query
|
|
|
Or operator
|
selects records that match at least 1 of 2 or more conditions in a query
|
|
|
Total row
|
used to count the number of values in a column
|
|
|
Calculated field
|
when a field displays a value that is calculated using other fields in the query
|
|
|
Expression
|
a calculation
|
