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

Question

Quizplus · Accepted Answer

The "Quantity sold" should always be a "Number" field because it represents a numerical value that can be used for calculations. Other fields like Customer number, Social security number, and Invoice number, although they contain numbers, are often treated as text to preserve formatting and prevent calculations. Total sales dollar amount is typically a "Currency" field.

When Creating a Table in Microsoft Access, Which of the Following