Which field type in an MS Access database table is most suitable for storing monetary values and financial transaction amounts to avoid rounding errors? MCQ with Answer and Explanation
Which field type in an MS Access database table is most suitable for storing monetary values and financial transaction amounts to avoid rounding errors?
A. Short Text
B. Number
C. Currency
D. Calculated
Answer: Option C
Solution (By JKSSB Mock Tests)
The Currency data type prevents rounding calculations during financial updates, locking precision values up to 4 decimal places.
Explanation:
The Primary Key is a field or combination of fields that uniquely identifies each record in an Access table and cannot contain null or duplicate values.
No comments yet. Be the first to start the discussion!