Cambridge IGCSE ICT 0417 – 18 Databases: Characteristics of Good Form Design
18 Databases
Objective
Know and understand the characteristics of good form design.
What is Form Design?
A form is a user‑interface component that allows data to be entered, edited or retrieved from a database. Good form design ensures that users can input data accurately, quickly and comfortably, reducing errors and improving overall system efficiency.
Key Characteristics of Good Form Design
Clarity and Simplicity – Use clear labels, avoid unnecessary fields, and keep the layout uncluttered.
Logical Flow – Arrange fields in a natural order that matches the user's mental model (e.g., personal details before contact details).
Appropriate Field Types – Use the correct control for the data (text boxes, drop‑down lists, radio buttons, check boxes, date pickers, etc.).
Consistent Layout – Align labels and input controls uniformly; use the same font and spacing throughout.
Validation and Error Handling – Provide real‑time checks (e.g., mandatory fields, format validation) and clear error messages.
Feedback to the User – Confirm successful submission and indicate required fields (e.g., with an asterisk).
Accessibility – Ensure forms are usable with keyboard only, screen readers, and have sufficient colour contrast.
Minimise Data Entry – Use defaults, auto‑complete, and look‑up lists where possible.
Security Considerations – Mask sensitive input (e.g., passwords), limit input length, and protect against injection attacks.
Typical Form Layout Elements
Element
Purpose
Best Practice
Title / Heading
Identifies the purpose of the form
Use concise, descriptive text (e.g., “Student Registration”)
Labels
Describe each field
Place to the left or above the field; associate with the control using for attribute
Input Controls
Collect data
Choose control type that matches data (e.g., <input type="date"> for dates)
Mandatory Indicator
Shows required fields
Use a red asterisk (*) and explain its meaning in a legend
Place near the offending field; use plain language
Design Checklist
Are all labels clear and positioned correctly?
Is the tab order logical for keyboard navigation?
Have appropriate field types been used?
Are required fields clearly marked?
Is real‑time validation implemented where feasible?
Do error messages explain the problem and how to fix it?
Is the form accessible to users with disabilities?
Are security measures (e.g., password masking) in place?
Is the overall layout visually balanced and not overwhelming?
Has the form been tested with representative users?
Suggested diagram: Typical form layout showing title, grouped sections, labels aligned left, input fields, mandatory indicators, and submit button.
Summary
Good form design is essential for reliable data capture in databases. By focusing on clarity, logical flow, appropriate controls, validation, accessibility and security, designers create forms that users can complete quickly and accurately, thereby improving data quality and system efficiency.