Case 1 - MaidToOrder
the Database for a Cleaning Service

question 37

Multiple Choice

Case 1 - MaidToOrder
The database for a cleaning service company contains the following table, named tblCustomer, that includes customer invoice data. The InvoiceNum, CustomerNum, and InvoicePaid fields contain text. The InvoiceDate field contains dates. The InvoiceAmt field contains numbers.
$$\begin{array} { | l | l | l | l | l | } \hline \text { InvoiceNum } & \text { CustomerNum } & \text { InvoiceDate } & \text { InvoiceAmt } & \text { InvoicePaid } \\\hline 631 & 13020 & 01 / 15 / 2013 & 200.00 & \mathrm { Y } \\\hline 632 & 15411 & 01 / 20 / 2013 & 685.00 & \mathrm { Y } \\\hline 633 & 10002 & 01 / 23 / 2013 & 75.00 & \mathrm {~N} \\\hline 634 & 13104 & 01 / 23 / 2013 & 150.00 & \mathrm {~N} \\\hline 635 & 12124 & 01 / 26 / 2013 & 75.00 & \mathrm { Y } \\\hline 636 & 13328 & 02 / 02 / 2013 & 350.00 & \mathrm { Y } \\\hline 637 & 10206 & 02 / 02 / 2013 & 175.00 & \mathrm {~N} \\\hline 638 & 10334 & 02 / 07 / 2013 & 450.00 & \mathrm { Y } \\\hline\end{array}$$
-Which of the following statements will select all invoices of $200.00 or more and arrange the invoices in ascending order by Customer number?

• A)Dim records =From customer In CustomerDataSet.tblCustomerWhere customer.InvoiceAmt > 200Order By invoice.CustomerNumSelect customer
• B)Dim records =From customer In CustomerDataSet.tblCustomerWhere customer.InvoiceAmt > 200Order invoice.CustomerNum AscendingSelect customer
• C)Dim records =From CustomerDataSet.tblCustomerWhere customer.InvoiceAmt > 200Order invoice.CustomerNumSelect customer
• D)Dim records =From customer In CustomerDataSet.tblCustomerWhere customer.InvoiceAmt < 200Order By invoice.CustomerNumSelect customer

---

Definitions:

Revenue And Expense

Key components of a profit-oriented organization's income statement, where revenue represents the total income earned and expense represents the cost incurred to earn that income.

Adjusted Trial Balance

A listing of all company balances after adjustments have been made for accruals, deferrals, and other adjustments during the accounting period.

Statement Of Owner's Equity

A financial document detailing changes in the equity of a company due to earnings, withdrawals, and other factors over a period.

Balance Sheet

A report detailing a corporation's assets, liabilities, and equity of shareholders at a certain moment.