All subjects · Information Technology · WIT14 3 hour practical exam on database solutions

Data entry and edit forms

Edexcel IAL Information Technology · WIT14 3 hour practical exam on database solutions

Specification 19.2.1 asks you to create data entry forms for new and existing data. A form question in recent papers carries about a dozen marks, and the examiner reports say default wizard forms earn few of them. This lesson covers what to add.

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

Practise this lesson

Entry forms and edit forms

Features that earn marks

FeatureWhy it helps
Meaningful title, for example 'Add a new bike'Users know what the form is for
Short instructions on the formUsers know what to do
Clear labels (captions), not raw field namesPlain language
Required fields marked with an asterisk and a note explaining itUsers know what must be completed
Generated fields (ID, status) disabled or lockedPrevents changes to values the system sets
Defaults (Status = Available, today's date)Faster, more consistent
Drop-downs, option groups, check boxesFewer typing errors
Sensible field widths, logical tab order, aligned controlsEase of use
A clearly labelled Save button with confirmationUsers know the record is saved, and can cancel

Based on features credited in Pearson's June 2024 and 2025 mark scheme and examiner reports.

Automating the save

A typical embedded save macro uses conditional logic:

If MsgBox("Save this bike?", 4) = 6 Then
    RunMenuCommand SaveRecord
    MessageBox "The bike has been saved."
    GoToRecord New
Else
    RunMenuCommand Undo
    MessageBox "The record was not saved."
End If

In the MsgBox function, 4 shows Yes and No buttons and 6 is the value returned when Yes is clicked (in VBA you can write vbYesNo and vbYes instead). The June 2024 paper asked for a save button with a confirmation prompt and a cancellation message, and the next ID generated automatically (for a numeric ID, a default value such as =DMax("ArtID","tblArt")+1). Read exactly what each paper asks for: in June 2025 the mark was for a message shown after saving, and asking 'Do you want to save?' instead was not credited. Screen print the form view and the design view of each macro and the property sheet showing settings such as default values.

Worked example

Design a form for staff to add a new bike to Harbour Bike Hire.

  1. Title 'Add a new bike'; instruction 'Complete all fields marked * then click Save bike'.
  2. BikeID generated and shown disabled; Model text box*; BikeType option group of four types*; DailyRate formatted as Currency with range validation*; HelmetIncluded check box.
  3. Button 'Save bike' running the If MsgBox ... macro; button 'Cancel and close'.
  4. Form opens on a new record; tab order follows the screen layout.

Answer: Every feature links to a user need: clarity, speed or accuracy.

Key idea: Entry forms open on a new record; edit forms find and change records with IDs locked. Earn marks with a meaningful title, instructions, clear labels, asterisks on required fields, disabled generated fields, defaults, drop-downs, sensible layout and a labelled save button with confirmation and cancellation messages. Evidence form view, design view and properties.

Check yourself

  1. Which setting makes a form open at a blank record so existing data cannot be overwritten?
    • Allow Deletions = Yes
    • Record Source = blank
    • Default View = Datasheet
    • Data Entry = Yes (or a GoToRecord New action when it opens)
    Show answer

    Data Entry = Yes (or a GoToRecord New action when it opens). Data Entry mode shows only new records.

  2. Why should an auto-generated ArtID be disabled or locked on the entry form?
    • So it is not saved
    • So users cannot change a value the system generates
    • So the form loads faster
    • Because IDs cannot be displayed
    Show answer

    So users cannot change a value the system generates. Mark schemes credit disabling generated fields: users should see but not edit them.

  3. What should accompany asterisks on required fields?
    • A red background on every field
    • A hidden field
    • A chart
    • A note explaining that * means the field must be completed
    Show answer

    A note explaining that * means the field must be completed. Users need to know what the symbol means.

  4. A form must show the customer's name while entering a hire. What should the form be based on?
    • A query joining tblHire and tblCustomer, or tblHire with a customer combo box
    • tblBike only
    • A report
    • A blank table
    Show answer

    A query joining tblHire and tblCustomer, or tblHire with a customer combo box. Forms needing fields from several tables are based on a query or use lookups.

  5. In the save macro, which part gives the user the chance to cancel?
    • GoToRecord New
    • The form title
    • The If test on a Yes/No message box
    • The default value
    Show answer

    The If test on a Yes/No message box. The message box asks the question; If decides what to do with the answer.

  6. The highest ArtID in tblArt is 1047. What does a default value of =DMax("ArtID","tblArt")+1 give for the next record?
    Show answer

    1048. DMax finds the highest existing value, 1047, then adds 1.

  7. Pearson's examiner reports say many candidates relied on the wizard's default form. Give two improvements that would make such a form easier to use.
    Show answer

    Add a meaningful title with instructions, and replace raw field names with clear labels and asterisks on required fields.. Any two specific features: title, instructions, clear labels, asterisks on required fields, disabled generated fields, drop-downs, defaults, sensible widths, a labelled save button.

Practise with instant feedback

Sources

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