Skip to content
CAT Study Hub

required

1 sub-question across 1 paper, 2 marks total.

Computer Applications Technology 2026

Question 5 — Database
5.1.12 marks

Open tblStartups in Design View. Make StartupName Required and set Field Size to 40.

Show answer
  1. Right-click tblStartups → Design View. Click the StartupName row.

  2. In Field Properties: Field Size = 40; Required = Yes.

Why this earns the marks

one property each. Required = Yes means no record can be saved without a name — it's a save-time check, not a typing-time restriction, so Access blocks the save action itself rather than preventing you from leaving the field empty while editing. Reducing Field Size may warn about possible data loss if a name is longer than 40, which you accept, because Field Size is a hard character limit: Access checks existing data against the new, smaller limit and flags anything that would be truncated, but the warning doesn't stop you from applying the change — it's informational, confirming you understand the risk.