Matching
Match each of the following with the correct definition or statement.
Premises:
A datasheet's records are placed in a determined order
An asterisk or question mark used in a query
A predefined Access formula that returns a value such as a subtotal or count
A combination of field names, operators and functions
A field of data that is created based on values of other fields
A statistic such as a subtotal or count is determined on a given field in a group of records
Responses:
Calculated field
Expression
Aggregate function
Sort
Function
Wildcard character
Correct Answer:
Premises:
Responses:
A datasheet's records are placed in a determined order
An asterisk or question mark used in a query
A predefined Access formula that returns a value such as a subtotal or count
A combination of field names, operators and functions
A field of data that is created based on values of other fields
A statistic such as a subtotal or count is determined on a given field in a group of records
Premises:
A datasheet's records are placed in a determined order
An asterisk or question mark used in a query
A predefined Access formula that returns a value such as a subtotal or count
A combination of field names, operators and functions
A field of data that is created based on values of other fields
A statistic such as a subtotal or count is determined on a given field in a group of records
Responses:
Related Questions
Q6: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB7032/.jpg" alt=" -An SQL statement
Q10: When a query is saved,it saves VBA
Q14: You want to search for all last
Q15: Which type of query retrieves data from
Q17: In Query Design View,you can drag the
Q19: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB7032/.jpg" alt=" -An SQL statement
Q30: The _ function returns the number of
Q36: When the comparison operator Null is used
Q68: The Find _ Query Wizard is used
Q71: In the query design grid,what characters surround