All subjects · Information Technology · WIT14 3 hour practical exam on database solutions
Importing, exporting and evaluating your tools
Edexcel IAL Information Technology · WIT14 3 hour practical exam on database solutions
Specifications 19.1.6 and 19.1.7 require you to import data from xls/xlsx, csv and txt files and export data to xls/xlsx, csv, txt, html and pdf files, and 19.1.8 asks you to evaluate the tools you used. Every recent paper has supplied a data file to import, and examiners check the record count.
File formats
| Format | What it is | Typical use |
|---|---|---|
| Excel (.xlsx) | Spreadsheet workbook | Data kept by staff in spreadsheets; export for further analysis and charts |
| CSV (.csv) | Plain text, one record per line, fields separated by commas | Moving data between almost any systems |
| Text (.txt) | Plain text, delimited (comma, tab) or fixed width | Exports from other systems; exam data files |
| HTML (.html) | A web page table | Publishing data on an intranet or website |
| PDF (.pdf) | Fixed-layout document | Export only: a printable, read-only copy of a report |
PDF is an output format; database software does not import data from it.
Importing well
1. Open the file first (in a text editor or spreadsheet) to see the delimiter, whether the first row holds field names, and the data in each column.
2. Decide which table(s) the data belongs in. Data that is not normalised should go into a holding (staging) table first, then into the proper tables with append queries.
3. In the import wizard set the delimiter, tick 'First row contains field names', set data types, and choose the primary key or append to an existing table.
4. Check: import errors table, data types, and the record count against the file.
A supplied file:
HireID,BikeID
109,B02
109,B05
110,B01loaded into a holding table and appended into tblHireItem (the hires 109 and 110 already exist, so referential integrity is satisfied):
INSERT INTO tblHire VALUES (109, 2, '2026-05-06', 2), (110, 4, '2026-05-07', 1);
CREATE TABLE tblImport (HireID INTEGER, BikeID TEXT);
INSERT INTO tblImport VALUES (109, 'B02'), (109, 'B05'), (110, 'B01');
INSERT INTO tblHireItem SELECT HireID, BikeID FROM tblImport;Result (1 row):
RecordsInTblHireItem
--------------------
14Exporting
- Export a query or report, not the whole table, when only some data is needed (and only data the recipient is entitled to).
- Excel or CSV when the recipient will work with the data further; PDF for a fixed report; HTML for publishing.
- In Access, External Data offers each format, and a saved export or the ExportWithFormatting macro action automates a regular export, which can be put on a button.
- Evidence: screen print the export settings and the opened exported file.
Evaluating the tools you used
Specification 19.1.8 asks you to evaluate how effective and appropriate your chosen tools were. For each tool, say what it did well and where it falls short in this scenario:
- Query or filter? A saved query can be reused, sorted, fed into a report or form and put on a button; a filter is quicker for a one-off look but is easily lost and harder to evidence.
- Report or exported file? A report gives a formatted, grouped, printable result; an export to Excel or CSV suits someone who will analyse the data further, and PDF suits a fixed copy.
- Import wizard or typing? Importing a file is faster and avoids typing errors, but only if the data types, delimiter and header row are set correctly and the record count is checked.
- Calculated field or stored value? A calculation in a query is always up to date; a stored value can become wrong.
Finish with a judgement: which tool best met the users' need, and why.
Worked example
A supplied text file of 240 sales has columns SaleID, SaleDate, CustomerID, CustomerName, ArtID, Price. How should you import it?
- Inspect the file: comma delimited, header row, one row per item sold, customer names repeated.
- Import into a holding table, then append SaleID, SaleDate, CustomerID into tblSale (one row per sale, using grouping or distinct values), and SaleID, ArtID, Price into tblSaleDetails.
- Customer names already belong in tblCustomer, so do not import them again into the sales tables.
- Show at least five imported records and the record count of each table as evidence.
Answer: Holding table, then append into the normalised tables, then evidence the counts.
Check yourself
- A comma separated file has one header row and then one record per line. It has 37 lines in total. How many records should be imported?
Show answer
36. 37 lines minus the header row.
- After the import shown in the lesson, how many records are in tblHireItem?
```sql
SELECT COUNT(*) FROM tblHireItem
```
Show answer
14. tblHireItem had 11 rows; 3 were appended, giving 14.
- Which format can a report be exported to but data is not normally imported from?
- CSV
- Excel
- Delimited text
Show answer
PDF. PDF is a fixed-layout output format.
- What does CSV stand for?
- Computer stored variables
- Common spreadsheet view
- Coded secure values
- Comma separated values
Show answer
Comma separated values. Fields are separated by commas.
- During import, the first row of the file reads 'HireID,BikeID'. What setting should you choose?
- Fixed width
- First row contains field names
- Import as a PDF
- Append the first row as a record
Show answer
First row contains field names. The header row supplies field names, not data.
- Why import an unnormalised file into a holding table first?
- Because tables cannot be imported directly
- To delete the original file
- So the data becomes a PDF
- So its data can be split into the correct normalised tables with append queries
Show answer
So its data can be split into the correct normalised tables with append queries. Importing straight into one table would copy the duplication into the database.
- Before appending, this query checks the holding table for rows that would break referential integrity. How many rows does it return?
```sql
SELECT * FROM tblImport WHERE HireID NOT IN (SELECT HireID FROM tblHire) OR BikeID NOT IN (SELECT BikeID FROM tblBike)
```
Show answer
0. Every imported row matches an existing hire and bike, so 0 rows break referential integrity and the append succeeds.
- The owner wants the same printed list of overdue hires every Monday. Which is the best evaluation of the tools?
- A saved query feeding a report is more appropriate than a filter, because the task is repeated weekly and needs a formatted printout
- A filter is best because filters are always more accurate than queries
- Exporting to PDF is best because the owner can then import the PDF back
- Typing the list into a word processor is best because it avoids the database
Show answer
A saved query feeding a report is more appropriate than a filter, because the task is repeated weekly and needs a formatted printout. Tool choice is judged against the need: repeated, printed output suits a saved query and a report.
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 examiner report, June 2024
- Pearson: WIT14/01 examiner report, June 2025
Last updated 8 November 2026. Spotted a mistake? Tell us.