This section provides a quick preview of questions from the document. It may not display every question or the complete wording of each one. For the full content, including diagrams, tables and other information, view the original PDF above.
Q1โ Section header โ
1.1Button [1.1 Colours Change the font size of mbQ1_1 to 12pt Add blue to
1.4Button [1.4 Word game] Initialise total to 0 Extract word from edit box and change to uppercase Test if it is not a single word (has spaces\ Clear edit box Set focus to the edit box
Q2โ Section header โ
2.1SQL statements
2.1.1Button
2.1.1List of employees SELECT * FROM tblEmployees ORDER BY JobTitle HourlyWage DESC Concepts: SELECT *
2.1.2Button [
2.1.2Engineers SELECT EmployeeID, LastName, FirstName FROM tblEmployees WHERE JobTitle LIKE "%Engineer Concepts:
2.1.3Button [
2.1.3Job titles SELECT DISTINCT JobTitle FROM tblEmployees OR SELECT JobTitle FROM tblEmployees GROUP BY JobTitle Concepts:
2.1.4Button [
2.1.4Remove records] DELETE FROM tblHourLogs WHERE HoursWorked = 99 Concepts: DELETE FROM tblHourLogs WHERE HoursWorked = 99 Information Technology/P1
Q2โ Section header โ
2.1.5Button [
2.1.5Overtime SELECT LastName, FORMAT(SUM((HoursWorked 8\ Hourly Wage
2.2DATABASE MANIPULATION using Delphi code
2.2.1Button [
2.2.1mployees with first aid Display column headings // Provided Initialise counter to 0 Set tblEmployees to start reading first record Loop while not tblEmployees.Eof
2.2.2Button [
2.2.2Add new employee] tblEmployees.Insert tblEmployees[ EmployeeID ] := EMP
2.2.3Button [
2.2.3Update hours worked] Get number of hours (iHours or sHours from edtQ2_2_3
Q3โ Section header โ
3.1.1Constructor method: Head er with correct parameter values (correct order, data types\ Assign customer ID parameter value to fCustomerID Assign container size parameter value to fContainerSize Assign storage period parameter value to fStoragePeriod
3.1.2getAmountPaid method: Function heading with real/double as return data type fAmountPaid assigned to result
3.1.3updateAmountPaid method: Procedure heading with real/double parameter value Increment fAmountPaid Using the parameter value
3.1.4calculateCost method: Function declared with double/real return data type If containerSize = Set initial cost to 1000.00 Else if containerSize =
3.1.5toString method: Labels ( Customer ID, Container size, Storage period Amount paid\ Correct attributes Correct conversions (amountPaid float; storagePeriod
Q3โ Section header โ
3.2.1Button [3.2.1 Insta tiate object] Extract customer ID from edit box Extract first character
3.2.2(a\ Button [3.2.2 (a\ Display amount due] Call the calculateCost method Display the amount due on pnlQ3_2_2
3.2.2(b\ Button [3.2.2 (b\ Process payment] Retrieve the amount from edtQ3_2_2 Call updateAmountPaid with extracted amount as argument Calculate amount due using the object methods
3.2.3Button [3.2.3 View details] Call the toString method Display in the richedit
4.1.1 Button [4.1 .1 Create harbour containers Loop 50 times Genera
4.1.2Button [4.1.2 Display harbour containers Set index to 0 Loop 5 times (rows\ sLine :=
4.2Button [4.2 Containers loaded to be shipped] Set TotalTons to zero (0\ Initialis string variable used for display Set array index (1\ Loop index < 50 If
Q1โ Section header โ
Q2โ Section header โ
Q3โ Section header โ
Q4โ Section header โ
Q1โ Section header โ
Q1โ Section header โ
Q1โ Section header โ
Q1โ Section header โ
Q1โ Section header โ
Q1โ Section header โ
Q1โ Section header โ
Q1โ Section header โ
Q1โ Section header โ
Q2โ Section header โ
Q2โ Section header โ
Q2โ Section header โ
Q2โ Section header โ
Q2โ Section header โ
Q2โ Section header โ
Q2โ Section header โ
Q2โ Section header โ
Q2โ Section header โ
Q2โ Section header โ
Q2โ Section header โ
Q2โ Section header โ
Q2โ Section header โ
Q2โ Section header โ
Q3โ Section header โ
Q3โ Section header โ
Q3โ Section header โ
Q3โ Section header โ
Q3โ Section header โ
Q3โ Section header โ
Q3โ Section header โ
Q3โ Section header โ
Q3โ Section header โ
3.2.2(a\ pnlQ3_2_2.Caption := Amount due: + Format( %.2m
Q3โ Section header โ
Q3โ Section header โ
Q3โ Section header โ
Q3โ Section header โ
Q4โ Section header โ
78.8,96.3,67.8,47.2,31.4,18.4,27,1.4,33.5,16.5,
58.3,9.9,62.9,11.8,62.5,59,13.4,49.8,60.4,74.5,
13.5,67.7,94,39.4,47.4,13.1,26.2,63,89,22.3, 54,16.9,38.6,46.2,22.5,11.4,65.1,48.6,41.4,47.9\ var frmQ4: Tfr mQ4; implementation {$R *.dfm} Information Technology/P1 26 DBE/
Q4โ Section header โ
Q4โ Section header โ
Q4โ Section header โ
Q4โ Section header โ
Q4โ Section header โ
Q4โ Section header โ