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 performs a database action; either make table,delete, update, or append
|
Action Query
|
|
|
Appends records from one table or query to another
|
Append Query
|
|
|
A type of function 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
|
|
|
String, numerical, and function statements used to find a record set.
|
Criteria
|
|
|
A type of action query that deletes a group of records from a table.
|
Delete Query
|
|
|
An icon avaiable in tables and forms that brings-up a blank version of the Datasheet view where you can either criteria to filter records.
|
Filter By Form
|
|
|
A type of action query that creates a new table from the existing subset of records.
|
Make-Table Query
|
|
|
A section of the report that contains elements that appear on all pages of the report.
|
Page Header
|
|
|
Where a dialog appears when the query is run prompting the user for information before displaying the datasheet.
|
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
|
|
|
A type of action query that makes global change to a subset of records in a table.
|
Update Query
|
