1.What data type should be assigned to fields which will be used in calculations?

A. Number

B. Text and number

C. Date

D. Text

E. Number and date

2. In order to join two fields in Microsoft Access:

A. the data types may be different as long as the data values match.

B. the data types must match exactly.

C. two fields cannot be joined in Access.

D. field names must be exactly the same, but the data types can be different.

3.In Microsoft Access, how should one delete a relationship in the relationship layout?

A. Delete the relationship in a Form.

B. In the relationship window single click on the relationship line to highlight it, then click on the delete key.

C. Delete the relationship in a query.

D. A relationship cannot be deleted in Access once it is created.

4.When creating a table in Microsoft Access, which of the following fields should ALWAYS be specified as a Number field (and should thus NEVER be specified as either a Date , Currency , or Text field)?

A. Quantity sold

B. Customer number

C. Social security number

D. Invoice number

E. Total sales dollar amount

5.Which of the following pieces of data would most likely be stored (rather than derived via a query) in a relational database based on the REA model and implemented in Microsoft Access?

A. The number of different inventory items purchased from a vendor during a month.

B. An individual customer s accounts receivable balance on a specific date.

C. The quantity on hand of a particular inventory item on a specific date.

D. Actual unit selling price of an inventory item on a specific sale.

E. The balance of the company s checking account on a specific date.