MS Access MCQ with Answers

All of these are valid data types in Microsoft Access.

• Number data type is used to store numeric values such as integers, decimals, and floating-point numbers.
• Text data type is used to store alphanumeric characters, such as names, addresses, and descriptions.
• Currency data type is used to store monetary values, such as currency amounts.

In addition to these, Microsoft Access also supports other data types such as Date/Time, Yes/No, Memo, and so on. The appropriate data type for a field in a Microsoft Access table depends on the nature of the data that will be stored in the field.