Nepal Agricultural Research Council2080 BSQuestion 3 of 10
Briefly explain the data types supported by MS-Access.
5 marks
Question source
- Exam year
- 2080 BS / 2023 AD
- Level
- Level 5 (T-5, Prabidhik, Computer Sahayak)
- Paper
- D-3 – Subjective
- Section
- Section B
Model answer
Types fix allowed values (consistent with ASI/SI papers): Short/Long Text (names, remarks), Number (age, qty with 0–100 rule), Currency (budget Rs.), Date/Time (trial date), Yes/No (germinated checkbox), AutoNumber (auto trial ID, ideal PK), Attachment (field photo PDF). Example: PlotNo = Short Text to keep leading zeros; Yield_kg = Number.