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 query that perfoms a database action: either make table, delet, update, or append.
|
action query
|
|
|
Appends records from one table or query to another table.
|
Append query
|
|
|
A type of function where the numerical values of a record set ary 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
|
|
|
Criteria are string, numerical, and function statements used to find a record set.
|
Criteria
|
|
|
A type of action query that delets a group of records from a table
|
delete query
|
|
|
An icon available in tables and forms that brings-up a blank version of the datasheet view where you can enter criteria to filter records.
|
Filter by form
|
|
|
A type of action query that creates a new table from an existing subset of records.
|
Make-table query
|
|
|
A section of a report that contains elements that appear on all pages of the report.
|
page header
|
|
|
where a dialong appears when the query in run prompting the user for information before displaying the dataset.
|
Parameter query
|
|
|
a section of a report that contains elements that appear only on the first and last pages of a report.
|
report header
|
|
|
a type of function where the numerical values of a record set are totaled
|
sum
|
|
|
an type of action query that makes a global change to a subset of records in a table.
|
update query
|
