Problemset

Bina Nusantara Skill Competition
Qualification Round
Sunday, 5 August 2007

Topic : Database – Form and Subform

you can download given source here : GreenCenter.mdb , bg_header.jpg

Create a form to help the frontliner in the Green Training Center to register new student , they can view all information provided.

You can create with given database : GreenCenter.mdb
This database includes 4 tables which has relationship among them as shown below.

Part 1
Create a form to submit the information of the new comer who taking the workshop
• Create a form and save as : Frm_Student
• Create this form using wizard using data from table student
• Using form style STONE
• Eliminated the record selector and dividing lines
• Add one button to add the new record to table student

Part 2
• Create a form and save as : Frm_Workshop_Reg
• In the header form , insert image bg_header.jpg
• Form Title with Text “GREEN TRAINING CENTER”, with Color Yellow , Font Tahoma and size 14
• Format the body form with backcolor : 12632256 (grey)
• Format the footer form with backcolor : 32768 (Green)
• Add box rectangle with backstyle transparent, Special Effect Etched
• Show the information : Day, Shift, SubjectID, StudentID and Student Name
• Format the font in the text and label with Font Tahoma, 10pt and Color Green
• Add one button to open Frm_Student
• Add one rectangle with backcolor 9868950(dark grey)
• Add one button to save the new record entered , and the record was saved in the table   WorkshopSchedule
• Add one rectangle with format : Special Effect Flat, BorderStyle:Dots, and backcolor : 8421376
• Add one button to present the next record
• Add one button to present the previous record
• Add one button to close the form

Sub form

• Add one subform and save as Subform_Subject
• Default view : Single Form
• Format with backcolor : 10092543 (Yellow)
• Present all subject information as following :
    o Registered : new created field
       This field presenting the amount of students that has been registered the selected workshop
        Format the field with adding text “Person(s)” after the value
    o SubjectID
    o SubjectName
    o CreditPoint
    o Price
       Format the field as following example : 2000 become this form Rp 2.000
    o TotalPrice : new created field
       This field presenting the price as the result from calculating Credit Point * Price
        Format the field as following example : 2000 become this form Rp 2.000

• The changes information in this subform is affected with the changes of SubjectID selected record in the main form
• Hide the Record Selector , Navigation Buttons and dividing lines

Layout frm_Student

Layout Frm_Workshop_Reg