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;
13 Cards in this Set
- Front
- Back
|
a blank version of the datasheet where you enter criteria statements
|
Filter By Form
|
|
|
string, numerical, and function statements used to find a record set
|
Criteria
|
|
|
a function where the numical values of a record set are totaled.
|
Sum
|
|
|
a type of funtion where the numerical values of a record set are totaled and divided by the number of records
|
Average
|
|
|
A type of function where the numbers of records are counted. Count can be used on both text and numerical fields.
|
Count
|
|
|
statements entered in square brackets, which will result in a dialog box prompting you for the criteria before the datasheet is displayed
|
parameter query
|
|
|
will modify or move a group of records
|
action queries
|
|
|
permanently removes a group of records from one or more tables
|
delete query
|
|
|
modifies data
|
update query
|
|
|
adds records from one table to another
|
append query
|
|
|
creates a new table from all or part of the data in another table
|
make-table query
|
|
|
a section of a report that contains elements appear only on the first and last pages of a report
|
Report header
|
|
|
appears on all pages in a report.
|
page header
|
