All subjects · Information Technology · WIT14 3 hour practical exam on database solutions
Improving data entry: help text, masks, controls and automation
Edexcel IAL Information Technology · WIT14 3 hour practical exam on database solutions
Specification 18.3.4 and 18.3.5 cover techniques that make data entry easier and more accurate: help text, input masks, drop-down boxes, radio buttons, check boxes and automation, and how to evaluate them.
Guiding the user
- Help text: instructions on the form, a field's Description (shown in the status bar in Access) or a control's tip that appears on hover. Tell users what to enter and in what form: 'Enter the hire length in whole days (1 to 14)'.
- Input mask: a template that controls what can be typed character by character, showing placeholders. Access mask characters include 0 (digit required), 9 (digit optional), L (letter required), ? (letter optional), A (letter or digit required), > (convert following letters to upper case). For example >L00 forces a capital letter then two digits, such as B07.
- An input mask restricts how data is typed; a validation rule checks the value once entered. They are often used together.
Choosing controls
| Control | Use when | Example |
|---|---|---|
| Drop-down (combo) box | Choosing one value from a list, especially a long or changing list (often a lookup to a table) | Pick the customer or the bike |
| List box | A short list always visible | Payment method |
| Radio buttons (option group) | Choosing exactly one from a few fixed options | Road, Mountain, Hybrid, Electric |
| Check box | A Yes/No value | Helmet included |
| Text box | Free values that cannot be listed | Surname, notes |
Each control reduces typing and limits users to valid choices.
Automation and evaluation
Automation removes entry steps altogether:
- Default values: today's date (=Date() in Access), Status set to 'Available'.
- Auto-generated IDs: AutoNumber, or the next ID calculated from the highest existing one (for a numeric ID in Access, a default value such as =DMax("HireID","tblHire")+1; DMax finds the highest existing value).
- Calculated values displayed on the form (hire cost) instead of typed.
- Macros that set values, save the record and confirm.
Evaluating these techniques: each improves accuracy and speed, but none guarantees correctness. A drop-down can still have the wrong item picked, defaults can be left unchanged when they should not be, and masks can frustrate users with unusual data (for example international phone numbers). Judge each against the users and the data.
Worked example
Design data entry for a new bike: BikeID (B plus two digits), Model, BikeType (four fixed types), DailyRate, HelmetIncluded, DateAdded.
- BikeID: auto-generated if possible; otherwise input mask >L00 plus a format validation rule.
- Model: text box with help text 'Manufacturer model name'.
- BikeType: option group of four radio buttons (or a combo box).
- DailyRate: text box formatted as Currency with a range rule 5 to 60.
- HelmetIncluded: check box.
- DateAdded: default value today's date.
Answer: Each field gets the control and aid that best suits its data.
Check yourself
- Which control best suits choosing one of three membership levels?
- A free text box
- A check box
- An input mask
- Radio buttons in an option group
Show answer
Radio buttons in an option group. Exactly one of a few fixed options: radio buttons.
- Which control suits a 'Paid' field with a Yes/No data type?
- A combo box listing every customer
- A check box
- A text box with an input mask
- A report
Show answer
A check box. Check boxes represent two states.
- In an Access input mask, what does 0 mean?
- The field can be left empty
- Any character is allowed
- The text becomes lower case
- A digit must be entered in that position
Show answer
A digit must be entered in that position. 0 is a required digit; 9 is an optional digit.
- Write an Access input mask for a code made of two capital letters followed by four digits, such as AB1234. Use > to force capitals.
Show answer
>LL0000. > converts letters to capitals, L is a required letter, 0 a required digit.
- Which technique automates entry of the date a hire is made?
- Adding a range check on HireDate
- Using a list box of all dates
- Setting the HireDate default value to today's date
- Adding help text to HireDate
Show answer
Setting the HireDate default value to today's date. A default value fills it in automatically.
- Which is a valid drawback of a strict input mask on a phone number field?
- International numbers with different formats cannot be entered
- It makes the field Currency
- It deletes existing records
- It prevents the table having a primary key
Show answer
International numbers with different formats cannot be entered. Masks enforce one pattern, which can block genuine data in another form.
- Explain how replacing a CustomerID text box with a drop-down list of customer names improves data entry.
Show answer
Users pick a customer by name instead of remembering and typing an ID, so it is quicker and they cannot enter an ID that does not exist.. A drop-down (lookup) lets users select recognisable names, cutting typing errors and preventing invalid IDs.
Sources
- Pearson Edexcel International Advanced Level in Information Technology specification (Issue 2, February 2021): Unit 4, Topics 17 to 19
- Pearson: WIT14/01 examiner report, June 2024
- Pearson: IAL Information Technology scheme of work for Unit 4
Last updated 8 November 2026. Spotted a mistake? Tell us.