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 query
|
|
|
common field
|
a field that appears in both tables, has the same data type, and contains the same values
|
|
|
condition
|
is a way of telling the query which data you are interested in seeing
|
|
|
expression
|
the calculations
|
|
|
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 a 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 are some times
|
|
|
one-to-many relationship
|
one record in the first table can match many records in the second table
|
|
|
or operator
|
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 dta it contains
|
|
|
referential intergrity
|
protects the data in the tables to make shure that data is not accidently deleted or changed, resulting in in inconsistant data
|
|
|
relationship
|
between two tables , you must design the tables so they contain a common field
|
|
|
simple query wizard
|
asks you what data you want to see by letting you slect options in dialog boxes
|
|
|
sort
|
arranges records from A to Z or from smallest to to largest
|
|
|
subdatasheet
|
contains the ralted records in the orders table
|
|
|
total row
|
count the number of values in column
|
