Printable worksheet ยท 1 of 4

A view should not destroy source records - Paper 1

Read the information, then answer the questions. An adult may read the instructions aloud. Show your working where asked.

Read before answering

Fictional rows: A = nature/100 pages; B = nature/50; C = history/110; D = nature/page count missing. Rule: an unknown page count does NOT satisfy a pages-greater-than test; do not replace it with zero. Compare nature AND pages > 70 with nature OR pages > 70. Filtering makes a view and must preserve the source rows.

Worksheet preview

This exercise is included in the paid course. Full-course fee: GBP 200.00 once. Register and enrol to complete all course exercises and download the course PDFs. Access begins after payment is confirmed.

Register and enrol

Already registered? Sign in