Study notes

Read these first, then work through a past paper question by question.

• Exam rules & strategy

  How the paper is structured, the 19 instructions in plain language, and a mark-hunting habit to use on every sub-question.

  ~6 min
• Word

  Word processing

  Document properties, styles, TOC, sections, SmartArt, captions, hyperlinks, citations, pictures, find & replace, columns and mail merge.

  ~19 min
• Excel

  Spreadsheets

  Cell references, the function toolkit for this paper, SUBTOTAL numbers, and the formatting tools examiners expect.

  ~10 min
• Access

  Database

  Field properties, input masks, queries, forms and reports in Access.

  ~10 min
• HTML

  Web design (HTML)

  Minimum page structure, tables, links and images, and text formatting tags.

  ~8 min
• Integration

  Integration

  Charts from sheet data, lookups across sheets, combining images into one logo, and mail merge.

  ~3 min