All subjects · Information Technology · WIT14 3 hour practical exam on database solutions
Menus, dashboards, buttons and macros
Edexcel IAL Information Technology · WIT14 3 hour practical exam on database solutions
Specification 19.2.1 and 19.2.4 ask you to create menus, dashboards and action buttons, and macros using conditional logic, import/export, queries and interface control. A dashboard question (about 5 marks in June 2024) gives one mark for a heading with well-labelled buttons and one for each correct action.
Menus and dashboards
- A menu (switchboard) form gives one button per task, so users never need to open tables or design views.
- A dashboard also shows key information at a glance: counts, totals, a chart, alongside buttons.
- Set the menu to open when the database starts (in Access, the Display Form option, or an AutoExec macro).
- Group buttons logically (Data entry, Reports, Exit) and label them by what they do for the user: 'Add a new bike', 'Show March hires over 50', 'Print bike income report', 'Exit the database'. The 2024 and 2025 examiner reports single out vague labels such as 'Run query' or 'Open form'.
Macro actions to know
| Task | Access macro action |
|---|---|
| Open a form, optionally at a new record | OpenForm (Data Mode Add), GoToRecord New |
| Run a query | OpenQuery |
| Open a report in Print Preview | OpenReport with View = Print Preview |
| Show a message | MessageBox |
| Ask a question and branch | If MsgBox(...) = ... Then ... Else ... End If |
| Save the current record | RunMenuCommand SaveRecord |
| Export data | ExportWithFormatting (Excel, PDF, RTF, text, HTML) |
| Import a file | ImportExportText or ImportExportSpreadsheet |
| Close a form or quit | CloseWindow, QuitAccess |
Embedded macros are attached to a button's On Click event.
Conditional logic in macros
Macros can make decisions, which the spec requires:
On Click of 'Export overdue hires':
If DCount("*", "qryOverdue") = 0 Then
MessageBox "There are no overdue hires to export."
Else
ExportWithFormatting qryOverdue, Excel Workbook
MessageBox "Overdue hires exported."
End IfOther examples: confirm before deleting; check a required field is filled before saving; warn if a value looks unusual. Evidence: screen print the form view of the menu and the design view of every macro, readable when zoomed.
Worked example
Create a dashboard for Harbour Bike Hire's owner.
- Heading 'Harbour Bike Hire: main menu'.
- Buttons: 'Add a new bike' (OpenForm frmBike, Data Mode Add); 'Show high value hires' (OpenQuery qryHighValue); 'Preview income by bike type' (OpenReport rptIncome, View Print Preview); 'Exit the database' (QuitAccess).
- A text box showing =DCount("*","tblHire") labelled 'Hires so far'.
- Set the dashboard as the display form at start-up.
Answer: Clear heading, task-named buttons, each with one correct action, and an at-a-glance figure.
Check yourself
- Which button label best follows Pearson's examiner advice?
- Preview the monthly sales report
- Open report
- Button 3
- Click here
Show answer
Preview the monthly sales report. Labels should say precisely what happens for the user.
- A button must open a report ready to check before printing. Which setting is needed?
- OpenReport with View set to Design
- OpenQuery
- OpenReport with View set to Print Preview
- OpenForm
Show answer
OpenReport with View set to Print Preview. The 2024 report noted fewer candidates ensured the report opened in Print Preview.
- Which macro action closes the whole database application?
- QuitAccess
- CloseWindow
- GoToRecord
- MessageBox
Show answer
QuitAccess. CloseWindow closes one object; QuitAccess exits the application.
- Which macro uses conditional logic?
- Open the hire form
- Run the income query
- Close the current window
- If the query returns no records, show a message; otherwise export it
Show answer
If the query returns no records, show a message; otherwise export it. Conditional logic branches with If ... Then ... Else.
- How can a menu form appear automatically when users open the database?
- Name it Menu1
- Set it as the display form or open it from an AutoExec macro
- Put it in a report
- Export it to PDF
Show answer
Set it as the display form or open it from an AutoExec macro. Start-up options or AutoExec run when the file opens.
- A 5-mark dashboard question gives 1 mark for a heading with four suitably labelled buttons and 1 mark for each button's correct action. How many marks are for actions?
Show answer
4. 5 minus the 1 mark for the heading and labels.
- Explain one benefit of providing a menu of buttons for a database used by staff with limited IT skills.
Show answer
Staff can carry out each task with one click without opening tables or design views, so they are less likely to make mistakes or damage the design.. A menu simplifies navigation and protects the structure from accidental changes by inexperienced users.
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
- Pearson: IAL Information Technology scheme of work for Unit 4
Last updated 8 November 2026. Spotted a mistake? Tell us.