Solved

Match Each of the Following with the Correct Definition or Statement

Question 61

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:

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
Related Questions

Q41: Which arithmetic operator signifies division?
A) ^
B) *
C)

Q42: Use the _ Query Wizard to guide

Q49: The _ function returns a number of

Q50: Which aggregate function is used to find

Q54: _ queries summarize data in which one

Q55: Explain the position and purpose for the

Q56: Which function should you use to calculate

Q59: To find all first names that are

Q66: Discuss the use of the * wildcard

Q75: The Find _ Query Wizard is used

Unlock this Answer For Free Now!

View this answer and more for free by performing one of the following actions

qr-code

Scan the QR code to install the App and get 2 free unlocks

upload documents

Unlock quizzes for free by uploading documents