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.

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

Practise this lesson

File formats

FormatWhat it isTypical use
Excel (.xlsx)Spreadsheet workbookData kept by staff in spreadsheets; export for further analysis and charts
CSV (.csv)Plain text, one record per line, fields separated by commasMoving data between almost any systems
Text (.txt)Plain text, delimited (comma, tab) or fixed widthExports from other systems; exam data files
HTML (.html)A web page tablePublishing data on an intranet or website
PDF (.pdf)Fixed-layout documentExport 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,B01

loaded 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
--------------------
14

Exporting

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:

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?

  1. Inspect the file: comma delimited, header row, one row per item sold, customer names repeated.
  2. 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.
  3. Customer names already belong in tblCustomer, so do not import them again into the sales tables.
  4. 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.

Key idea: Import from Excel, CSV and text; export to Excel, CSV, text, HTML and PDF. Inspect the file first, use a holding table for unnormalised data, set delimiter, header row and data types, and check the record count. Export only what is needed in the format the recipient needs. Evaluate each tool (query or filter, report or export, import or typing) against the scenario.

Check yourself

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

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

  3. Which format can a report be exported to but data is not normally imported from?
    • PDF
    • CSV
    • Excel
    • Delimited text
    Show answer

    PDF. PDF is a fixed-layout output format.

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

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

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

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

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

Practise with instant feedback

Sources

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