Case Based Critical Thinking QuestionsCase 6-3Akash 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])


Answer: B

Computer Science & Information Technology

You might also like to view...

After you make changes to a photo album in the Edit Photo Album dialog box, click the ____ button to apply the changes.

A. Create B. Cancel C. Edit D. Update

Computer Science & Information Technology

To change the list of choices in a single or multivalued lookup field, open the table in Design view, select the field to be modified, and click the _____ tab in the Field Properties pane.

A. Modify B. Change C. Edit D. Lookup

Computer Science & Information Technology

Users have reported choppy audio in phone conversations since the implementation of SIP phones on the network. Which of the following should be implemented to alleviate the delays?

A. Caching B. VoIP C. QoS D. SMTP

Computer Science & Information Technology

What theme is used to apply material for API Level 20 and lower?

a. @android:style/Theme.AppCompat b. @style/Theme.AppCompat c. @android:style/Theme.Material d. @android/Theme.Material

Computer Science & Information Technology