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.

Practise this in the app: instant marking and a fix for every mistake. Free, no email needed to start.

Practise this lesson

Guiding the user

Choosing controls

ControlUse whenExample
Drop-down (combo) boxChoosing one value from a list, especially a long or changing list (often a lookup to a table)Pick the customer or the bike
List boxA short list always visiblePayment method
Radio buttons (option group)Choosing exactly one from a few fixed optionsRoad, Mountain, Hybrid, Electric
Check boxA Yes/No valueHelmet included
Text boxFree values that cannot be listedSurname, notes

Each control reduces typing and limits users to valid choices.

Automation and evaluation

Automation removes entry steps altogether:

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.

  1. BikeID: auto-generated if possible; otherwise input mask >L00 plus a format validation rule.
  2. Model: text box with help text 'Manufacturer model name'.
  3. BikeType: option group of four radio buttons (or a combo box).
  4. DailyRate: text box formatted as Currency with a range rule 5 to 60.
  5. HelmetIncluded: check box.
  6. DateAdded: default value today's date.

Answer: Each field gets the control and aid that best suits its data.

Key idea: Help text guides; input masks control typing (0 digit, L letter, > upper case); combo boxes and radio buttons limit choices; check boxes for Yes/No; defaults, generated IDs and calculated values automate entry. None guarantees correctness, so evaluate against users and data.

Check yourself

  1. 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.

  2. 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.

  3. 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.

  4. 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.

  5. 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.

  6. 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.

  7. 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.

Practise with instant feedback

Sources

Last updated 8 November 2026. Spotted a mistake? Tell us.