Your going about the right way to get help. Every one in here is not an expert, they are people just like you. They will help if they can, but if your pc is not working it is not their fault.
Hopefully some of the answers you need are below. it is a common problem i see, but is usually a simple fault.
1.) (and im not saying your stupid but even the experts can get it wrong). Double check all your cables, especially the SATA and power leads to the DVD. If they are right and in the right way around, try plugging the SATA lead into another SATA port on the motherboard making sure they are fully in as they can be tight.
Also are there "jumpers" on the back of the HDD and DVD? if so are these set correctly for your PC? (usually removing them will default to automatic, but not always the case).
EDIT:
just seen your post about it showing in the bois, so the above should be correct on your PC)
2.) The disk that you are tying to install windows from:
Have you used this disk before from boot? If it is not made correct it may not be a "bootable disk" although will still work within windows (i.e on a pc with windows currently installed).
If it is not a genuine Windows disk (even if a non genuine disk boots in one pc it may not work in another - try another disk).
If it is a genuine windows disk and not too scratched, you should have no problem (OEM or Retail make no difference at this stage).
3.) If it is definitely a "bootable disk" double check the BOIS, as it may not have saved the boot order you set (also check that the BOIS is showing the DVD drive, if it is not there is a fault somewhere).
Most/some modern motherboards have a "special" boot menu, (in addition the the BOIS order), by pressing an F key to get to the menu, this is usually the best way to boot from DVD if you have this option. (post what motherboard you have and someone may tell you what F key)
Assuming that you have not changed other settings in your BIOS and if all the above are right you SHOULD be given the option to boot from any "bootable disk" in the DVD drive (this should be irrelevant to any RAID or OEM windows issues, they will arise further on if you have any).
You mention "IDE RAID AND AHCI" this should be set to AHCI (unless you are setting up a RAID array. If you don't know what this is, then you are not setting one up

). However i think this will only affect the HDD and not your ability to boot from the DVD (anyone please correct me if i am wrong on this)
I have seen people suggesting using "Optimized Defaults" for the BIOS (removing battery and all). I very much doubt this is your problem as this would typically cause different problems than you are reporting (and if it is this OCuk should help with this as your bundle was preclocked). Also using the "Optimized Defaults" will remove the Overclock from the motherboard and reset your boot order too.
Usually when i have seen this problem it is the windows disk or boot order at fault.
If you are sure all the above are correct and it is still not working or you are unsure on anything, ask politely and there are allot of good unpaid people here that will try to help you.
If you know nothing/lilttle about PC's (as you said above + you had overclockers set the overclock for you) maybe it would be best to take the PC and the disk to a shop an have them set it up for you (setting a pc up is only easy when you know how).
(how bad must i want to get access to the MM section !!)
Hope this helps
Jonny