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.
Entry forms and edit forms
- A data entry form adds new records. Set it to open at a new, blank record (Data Entry = Yes in Access, or a GoToRecord New action), so existing records cannot be overwritten by accident.
- An edit form finds and changes existing records: a combo box to find the record, then editable fields, with fields that must not change (the ID) locked.
- Base each form on a table or, if it needs fields from several tables or a filter, on a query.
Features that earn marks
| Feature | Why it helps |
|---|---|
| Meaningful title, for example 'Add a new bike' | Users know what the form is for |
| Short instructions on the form | Users know what to do |
| Clear labels (captions), not raw field names | Plain language |
| Required fields marked with an asterisk and a note explaining it | Users know what must be completed |
| Generated fields (ID, status) disabled or locked | Prevents changes to values the system sets |
| Defaults (Status = Available, today's date) | Faster, more consistent |
| Drop-downs, option groups, check boxes | Fewer typing errors |
| Sensible field widths, logical tab order, aligned controls | Ease of use |
| A clearly labelled Save button with confirmation | Users 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 IfIn 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.
- Title 'Add a new bike'; instruction 'Complete all fields marked * then click Save bike'.
- BikeID generated and shown disabled; Model text box*; BikeType option group of four types*; DailyRate formatted as Currency with range validation*; HelmetIncluded check box.
- Button 'Save bike' running the If MsgBox ... macro; button 'Cancel and close'.
- Form opens on a new record; tab order follows the screen layout.
Answer: Every feature links to a user need: clarity, speed or accuracy.
Check yourself
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
Sources
- Pearson Edexcel International Advanced Level in Information Technology specification (Issue 2, February 2021): Unit 4, Topics 17 to 19
- Pearson: WIT14/01 question paper, June 2024
- Pearson: WIT14/01 mark scheme, June 2024
- Pearson: WIT14/01 examiner report, June 2024
- Pearson: WIT14/01 examiner report, June 2025
Last updated 8 November 2026. Spotted a mistake? Tell us.