TAKE a screenshot of the report.
PASTE the screenshot into document TASK A2
RESAVE TASK A2
Task A2d
Brogan wants to add an additional field to the CUSTOMER table to include the
Customer Contact Number.
Field name Data type Field size
Customer ID Text 6
Customer Name Text 50
Customer Contact Number
Email address Text 100
Preferred Contact Method Lookup list:
Mobile
Email
Set as ‘limit to list’
Answer these questions in the document TASK A2
(i) Give the most appropriate data type Brogan should use for the
Customer Contact Number field.
(1)
(ii) Give the most appropriate field size Brogan should use for the
Customer Contact Number field.
(1)
(iii) Identify which field would be used as a foreign key in the PARTY table.
(1)
RESAVE TASK A2
10 P71376RA
(iv) Add a record, to the CUSTOMER table, that stores these customer details:
Customer ID SA1203
Customer Name Samuels
Email address samuels@fortran.online
Preferred Contact Method Email
(2)
RESAVE the CUSTOMER table.
TAKE a screenshot of the CUSTOMER table in datasheet view showing the
new record.
PASTE the screenshot into document TASK A2
RESAVE TASK A2
Task A2e
Answer these questions in the document TASK A2
(i) The PARTY table includes the Date field.
State one appropriate validation check that could be used on the Date field.
(1)
(ii) The CUSTOMER table includes the Preferred Contact Method field.
Explain one reason why the field uses ‘limit to list’ on the lookup list.
(2)
RESAVE TASK A2
SAVE TASK A2 as a PDF
(Total for Task A2 = 25 marks)
P71376RA 11
Turn over
Task A3
CREATE a folder TASK A3
Brogan wants you to create two web pages for The Perfect Party’s new website. Content
for the web pages is stored in the file WEB PAGES
She wants you to create these two linked pages:
• Home
• Birthday
Both web pages MUST be saved as .html
Task A3a
(i) Create a template for the web pages. The template MUST include:
• the logo you created in Task A1b
• the text, ‘IT’S PARTY TIME’ in a sans serif font and uppercase
• a navigation bar with HTML links to each of the pages
• a page title set as <h1>
• this colour scheme:
• background colour #FAEBD7
• text colour #B676B1
(6)
(ii) Create the Home page using the template. The Home page MUST include:
• the text from the WEB PAGE document
• an HTML table that:
• includes the table information from the WEB PAGE document
• is customised so that row 1:
• is merged across all columns
• has a dark background and white text
• is centre aligned.
(5)
12 P71376RA
SAVE the Home page as INDEX in your TASK A3 folder
(iii) Create the Birthday page using the template. The Birthday page MUST include:
• the text from the WEB PAGE document
• two appropriate images set to 450 × 300 pixels
• a footer with:
• the background set to a different colour
• an email link to brogan@tpp.service
(4)
SAVE the Birthday page as BIRTHDAY in your TASK A3 folder
(Total for Task A3 = 15 marks)
TOTAL FOR SECTION A = 50 MARKS
P71376RA 13
Turn over
