Multiple Choice
Case Based Critical Thinking Questions
Akash created a custom form for his supervisor that includes a subform based on a query for unpaid invoices. After creating the form and viewing it in Form view, Akash needs to make some changes. Decide which options are best for Akash to use to make the necessary changes to the custom form design.
-Akash has included a calculated field in the subform which was created using a query for unpaid invoices. The calculated field should show the total amount of unpaid invoices from the InvoiceAmt field; however, the form does not show the calculation in Form view. Which expression will solve this problem?
A) Sum([InvoiceAmt])
B) =Sum([InvoiceAmt])
C) Count([InvoiceAmt])
D) =Count([InvoiceAmt])
Correct Answer:

Verified
Correct Answer:
Verified
Q13: The expression =Sum([InvoiceAmt])might be found in which
Q18: To avoid typing errors when creating a
Q21: Which key on the keyboard may be
Q24: A value that is the result of
Q40: A customizable form that displays multiple records
Q63: The Record Source property specifies the table
Q69: Case Based Critical Thinking Questions<br>Carlos has created
Q69: Controls placed at the top of a
Q73: Set the _ property to No to
Q74: The Control Source property for a calculated