MIS access Exam2 UNH |Questions
Solved 100% Correct| Verified Solutions
OR Logical operators - ANSWER returns records meeting any of the specified criteria
Referential Integrity - ANSWER Rules in a database that are used to
preserve relationships between tables when records are changed
Sort row - ANSWER A row in query design view that enables you to sort in ascending
or descending order
Wildcard - ANSWER A special character that can represent one or more characters in
a criterion of a query
Aggregate Function - ANSWER Performs calculations on a entire column of data
and returns a single value. Includes functions such as sum, avg, and count
Expression - ANSWER Formula used to calculate new fields from the values in
existing fields
Grouping - ANSWER Allows you to summarize your data by the values of a field
Property Sheet - ANSWER Enables you to change settings such as a number
format, number of decimal places, and caption, among many others
Totals Query - ANSWER Makes an additional row available in the query design grid.
Used to display aggregate data when the query is run
, data Validation - ANSWER A set of constraints or rules that help control how data is
entered into a field
Input Mask - ANSWER Enables you to restrict the data being input into a feild
by specifying the exact format of the data entry
Parameter Query - ANSWER A select query where the user provides the criterion at
run time
Validation Rule - ANSWER Prevent invalid data from being entered into a field
Controls - ANSWER The text boxes, buttons, boxes, and other tools you use to add,
edit, and display the data in a form or report
Layout view - ANSWER Enables users to make changes to the layout while viewing
the data on the form or report
Record source - ANSWER The table or query that supplies the records for a form
or report
Report View - ANSWER Enables you to see what a printed report will look like in
a continuous page layout
Bound Control - ANSWER Control that is connected to a field in a table or query
Calculated Control - ANSWER a control contain an expression that generates a
calculated result
Solved 100% Correct| Verified Solutions
OR Logical operators - ANSWER returns records meeting any of the specified criteria
Referential Integrity - ANSWER Rules in a database that are used to
preserve relationships between tables when records are changed
Sort row - ANSWER A row in query design view that enables you to sort in ascending
or descending order
Wildcard - ANSWER A special character that can represent one or more characters in
a criterion of a query
Aggregate Function - ANSWER Performs calculations on a entire column of data
and returns a single value. Includes functions such as sum, avg, and count
Expression - ANSWER Formula used to calculate new fields from the values in
existing fields
Grouping - ANSWER Allows you to summarize your data by the values of a field
Property Sheet - ANSWER Enables you to change settings such as a number
format, number of decimal places, and caption, among many others
Totals Query - ANSWER Makes an additional row available in the query design grid.
Used to display aggregate data when the query is run
, data Validation - ANSWER A set of constraints or rules that help control how data is
entered into a field
Input Mask - ANSWER Enables you to restrict the data being input into a feild
by specifying the exact format of the data entry
Parameter Query - ANSWER A select query where the user provides the criterion at
run time
Validation Rule - ANSWER Prevent invalid data from being entered into a field
Controls - ANSWER The text boxes, buttons, boxes, and other tools you use to add,
edit, and display the data in a form or report
Layout view - ANSWER Enables users to make changes to the layout while viewing
the data on the form or report
Record source - ANSWER The table or query that supplies the records for a form
or report
Report View - ANSWER Enables you to see what a printed report will look like in
a continuous page layout
Bound Control - ANSWER Control that is connected to a field in a table or query
Calculated Control - ANSWER a control contain an expression that generates a
calculated result
