Examlex

Solved

Case 1 - MaidToOrder
the Database for a Cleaning Service

question 14

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.
 InvoiceNum  CustomerNum  InvoiceDate  InvoiceAmt  InvoicePaid 6311302001/15/2013200.00Y6321541101/20/2013685.00Y6331000201/23/201375.00 N6341310401/23/2013150.00 N6351212401/26/201375.00Y6361332802/02/2013350.00Y6371020602/02/2013175.00 N6381033402/07/2013450.00Y\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}
-You are responsible for connecting the Access database that contains the tblCustomer table to an application.You must first use the Data Source Configuration Wizard to ____.


Definitions:

Exercise

Exercise is any bodily activity that enhances or maintains physical fitness and overall health and wellness.

Reduce

To decrease in size, amount, extent, or number.

Ice Water

Water that has been chilled to a temperature at or near its freezing point, often used for drinking or cooling purposes.

Ultrasonic Sounds

Sounds that have frequencies above the upper limit of human hearing, typically greater than 20,000 Hz.

Related Questions