In order to join two fields in Microsoft Access the data types may be different

Question

In order to join two fields in Microsoft Access the data types may be different as long as the data values match. the data types must match exactly. two fields cannot be joined in Access. field names must be exactly the same, but the data types can be different. QUESTION 2 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)? O Quantity sold Customer number Social security number Invoice number Total sales dollar amount

Explanation / Answer

For first mcq the correct answer is 2 option

ForSecond mcq the correct options are 1 and 5 as the quantity sold and total sales dollar amount should have numeric values in the table and the rest fields can be in any datatype.

I hope this will gonna help you

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.