| The
following is a sample of a computerised database:
|
| |
|
|
| |
Surname
|
Forename |
House |
Year |
| Smith |
Joe |
X |
1 |
| Burns |
Joseph |
C |
2 |
| Curran |
Aidan |
O |
1 |
Taylor
|
Alan |
X |
1 |
| Davis |
Joanne |
O |
2 |
| Thomson |
Mary |
X |
2 |
| Houten |
Anne |
X |
2 |
| McCann |
Anna |
C |
2 |
| Smith |
Ann |
L |
1 |
| Smyth |
Ann |
O |
1 |
| McCain |
Alan |
L |
1 |
| Thompson |
James |
C |
2 |
|
|
| |
|
|
| 1. |
Copy and complete
the table below if the Surname field was sorted in ascending order.
|
(4) |
| |
|
|
| |
Surname
|
Forename |
House |
Year |
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
|
|
| |
|
|
| 2. |
Copy and complete
the table below if the House field was sorted in ascending order
and the Year field was sorted in descending order.
|
(4) |
| |
|
|
| |
Surname
|
Forename |
House |
Year |
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
|
|
| |
|
|
| 3. |
Copy and complete
the table below if the Forename field was sorted in ascending order
and the surname field was sorted in ascending order.
|
(4) |
| |
|
|
| |
Surname
|
Forename |
House |
Year |
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
|
|
| |
|
|
| |
Total |
(12) |
