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
|
action query
|
a query that performs a database action; either make a table, delete, update, or append
|
|
|
append query
|
appends records from one table or query to another
|
|
|
average
|
a type of function where the nummerical values of a record set are totaled and divided by the number of records
|
|
|
count
|
a type of function where the numbers of records are counted. count can be used on both text and numerical fields
|
|
|
criteria
|
they are string, numerical, and function statements used to find a record set
|
|
|
delete query
|
a type of action query that deletes a group of records from a table
|
|
|
filter by form
|
it is a blank version of the data sheet where enter criteria statements
|
|
|
make-table query
|
a type of action query that creates a new table from an existing subset of records
|
|
|
page header
|
a section of a report that contains elements that appear on all pages of the report
|
|
|
parameter qyery
|
where a dialog appers when the query is run prompting the user for information before displaying the data sheet
|
|
|
report header
|
a section of a report that contains elements that appear only on the first and last pages of a report
|
|
|
sum
|
a type of function where the numerical values of a record set are totaled
|
|
|
update query
|
a type of action query that makes a global change to a subset of records in a table
|
