Problemset

Bina Nusantara Skill Competition
Qualification Round
Sunday, 5 August 2007

Topic : Database - Report

Click here to download required files to accomplish following instuctions

(Use OrderDB2.mdb to do following instructions)

Submitted File : OrderDB2.mdb

Instruction :

• Create a report named LateReport which reports occurrence of late shipping to customer as shown in LateReport1.gif, LateReport2.gif, LateReport3 .gif, LateReport4.gif
  (A shipping is late when the shipping date is late than the required date)

• Use report template design as shown
• Report titles is “Late Shipping Report” with Tahoma 24pt bold, and position is in the center of report
• Year is shown per month, or new page
• Month is shown per month, or new page
• Header OrderID, Product Name and Late shipping is shown per month, or new page
• For year :Use font : Arial 16pt, bold, left , font color RGB 0 0 255
• For month : Use font : Arial 11pt, bold, left , font color is RGB 0 0 0
  And month is displayed in format “mmmm”
• For header OrderID, productname, late shipping
  Use font : Arial 10pt, bold, left , font color is RGB 0 0 0
• For data of OrderID, productname, late shipping
  Use font : Arial 10pt, normal, font color is RGB 0 0 0
• For summary per month
  Use font : Arial 9pt, bold, font color is RGB 0 128 128
• For summary per year
  Use font : Arial 9pt, bold, font color is RGB 0 0 255
• Design the summary per year as shown in the picture
• Give a box around the summary per year with the proper design/effect as shown in the picture (border is 5pt)
• Give a line under the text summary per year as shown, use the proper border style, the color is black with 4pt width

• For every page shows the time at the left side and page information at the right side
• Give report background with wheel.gif (please zoom the picture) at the center of report
• Report can be resized, min and max button is showed
• When report is closed, display a message “Thank You”
• When there is no late data in this report, then display a message “There is No Late Shipping”

• Data for report and summary per year and month is correctly shown as in the picture (notice the order of data)
• Overall, create and design your report properly as shown in the picture