Solved

Match Each of the Following with the Correct Definition or Statement

Question 63

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 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
A combination of field names, operators and functions
A predefined Access formula that returns a value such as a subtotal or count
Responses:
Aggregate function
Function
Sort
Expression
Calculated field
Wildcard character

Correct Answer:

A datasheet's records are placed in a determined order
An asterisk or question mark used in a query
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
A combination of field names, operators and functions
A predefined Access formula that returns a value such as a subtotal or count
Related Questions

Q33: The _ function returns a number of

Q51: Which function should you use to calculate

Q60: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TBX8825/.jpg" alt=" You want to

Q61: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TBX8825/.jpg" alt=" In the accompanying

Q61: A select query can be used to

Q62: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TBX8825/.jpg" alt=" In the query

Q64: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB7032/.jpg" alt=" -An SQL statement

Q66: A summary query calculates statistics about _.<br>A)

Q68: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TBX8825/.jpg" alt=" In the accompanying

Q74: Explain the relationship between the Like operator