Page 1088 - SUBSEC October 2017_Neat

- 8 -

(f) Identify the database feature that could be used to arrange the registration number of
vehicles in ASCENDING order.
..............................................................................................................................................
(1 mark)
(g) The report below is to be generated from your database.

Make Model Registration Number Colour DO NOT WRITE IN THIS AREA
Audi A4 PCE 427 Silver

Audi S4 PCS 4 White
BMW X3 PBH 2340 Red
BMW X5 PCY 888 Blue

Mercedes C180 PBB 3962 Green
Mercedes E200 PBR 4747 Black

Mercedes E200 PCT 6531 Gold
Mercedes S500 PDM 1 Black

Generate this report and save your database.
(2 marks)
Save your database with the filename DO NOT WRITE IN THIS AREA
DEALERSHIPCANDIDATENUMBER: cars(candidate#) eg. cars(12345667).

Total 20 marks
4. WEBPAGE DESIGN

Amery created a website for his small photography business and was eager to have it published.
However, he was told that he should consider completing some checks before doing so.

(a) Insert 1st, 2nd and 3rd in the following table to indicate the order in which the activities
must be completed.

Activity Rank
Use a test audience.
Maintain a website.
Verify that all the hyperlinks work correctly.
(3 marks)
DO NOT WRITE IN THIS AREA
(b) Give ONE example of a hyperlink that could be used on the webpage. Explain its purpose.

..............................................................................................................................................

..............................................................................................................................................
(2 marks)
Total 5 Marks
GO ON TO THE NEXT PAGE
01229032 SPEC/2017
‘‘*’’Barcode Area”*”
Sequential Bar Code