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.
$$\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 ____.

• A)test to see if the database is connected to the application
• B)add a new data source
• C)preview the contents of the dataset
• D)bind the controls to the dataset

---

Definitions:

Revenue-Maximizing Price

The optimal price of a good or service that maximizes the total revenue for a seller.

Demand Function

An equation that describes the quantitative relationship between the demand for a good and various factors affecting it, such as price, income, and price of related goods.

Price Elasticity

A measure of how much the quantity demanded of a good responds to a change in the price of that good, reflecting the sensitivity of consumers to price changes.

Normal Goods

Normal goods are goods whose demand increases when consumer income rises, and decreases when consumer income falls, opposite to inferior goods.