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 table.
|
Append Query
|
|
|
A type of function where the numerical values of a record set are totaled are 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
|
|
|
Cirteria are 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 avalible 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 the report that contains elements that appears on all pages of the report.
|
Page Header
|
|
|
Where a dialog apperars when the query is run prompting the user for information before displaying the dataset.
|
Parameter Query
|
|
|
A section of the 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
|
