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.

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

Practise this lesson

Menus and dashboards

Macro actions to know

TaskAccess macro action
Open a form, optionally at a new recordOpenForm (Data Mode Add), GoToRecord New
Run a queryOpenQuery
Open a report in Print PreviewOpenReport with View = Print Preview
Show a messageMessageBox
Ask a question and branchIf MsgBox(...) = ... Then ... Else ... End If
Save the current recordRunMenuCommand SaveRecord
Export dataExportWithFormatting (Excel, PDF, RTF, text, HTML)
Import a fileImportExportText or ImportExportSpreadsheet
Close a form or quitCloseWindow, 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 If

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

  1. Heading 'Harbour Bike Hire: main menu'.
  2. 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).
  3. A text box showing =DCount("*","tblHire") labelled 'Hires so far'.
  4. 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.

Key idea: Menus give one clearly labelled button per task; dashboards add at-a-glance information. Know OpenForm, OpenQuery, OpenReport (Print Preview), MessageBox, GoToRecord, SaveRecord, ExportWithFormatting, import actions, CloseWindow and QuitAccess, and If ... Then ... Else for decisions.

Check yourself

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

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

  3. Which macro action closes the whole database application?
    • QuitAccess
    • CloseWindow
    • GoToRecord
    • MessageBox
    Show answer

    QuitAccess. CloseWindow closes one object; QuitAccess exits the application.

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

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

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

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

Practise with instant feedback

Sources

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