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}$$
-To create a DataGridView control on the form,you would click on the ____ object in the Data Sources window and drag it to the form.
A)CustomerNum
B)InvoiceNum
C)CustomerDataSet
D)tblCustomer

Question

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}$$
-To create a DataGridView control on the form,you would click on the ____ object in the Data Sources window and drag it to the form.
A)CustomerNum
B)InvoiceNum
C)CustomerDataSet
D)tblCustomer

Quizplus · Accepted Answer

The best choice would be to select the tblCustomer table from the Data Sources window, as this is the table containing the relevant invoice data needed to create the DataGridView control on the form. Selecting the CustomerNum or InvoiceNum fields would not provide all the necessary information needed for the DataGridView control, and selecting the CustomerDataSet may not be necessary as the tblCustomer table can be accessed directly.

Case 1 - MaidToOrder the Database for a Cleaning Service

Case 1 - MaidToOrder
the Database for a Cleaning Service