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 conditios in a query.
|
|
Autofilter
|
is a menu that opens when you click the arrow or 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
|
is a field that appears in both tables, has the data type, and contains the same values.
|
|
condition
|
(also called a Criterion) is a way of telling the query which data you are interested in seeing.
|
|
expression
|
(the calculation) field name containing spaces
|
|
filter
|
temporarily displays records in a datasheet based on the condition that you specify.
|
|
filter by form
|
you can use this when 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 can select a field value (such as Oak Office Desk) or part of a field value (such as the just letter D) in a datasheet, and then click the selection button in the sort & filter group in the home tab.
|
|
foreign key
|
the common field in the related table when it is used in the relationship.
|
|
multitable query
|
Queries that are based on more that one table.
|
|
one-to-many relationship
|
one record in the first table (called the primary table) can match many (actually, zero, one, or many) records in the second table (called the related table)
|
|
Or operator
|
selects record that match at least one of two or more conditions in a query.
|
|
Query
|
is a database object that lets you ask the database about the data it contains.
|
|
referential intergrity
|
protects the data in the tables to make sure that data is not accidentally deleted or changed, resulting in inconsistent data.
|
|
relationship
|
when a database contains more than one table,as most databases do, the feature of the database management system that lets you connect the data in the tables.
|
|
simple query wizard
|
asks you what data you want to see by letting you select options in dialog boxes.
|
|
sort
|
when you view field values in ascending or descending order from A to Z or from smallest to largest.
|
|
subdatasheet
|
contains the related records in the order table(the related table) you can use it to make changes to the related records.
|
|
Total row
|
used when viewing a tavle or query datasheet to count the number of values in a column
|