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