" Most of the new boards show 1 x ATA/133 + 4 x SATAII (w/ RAID) Supports RAID 0, 1 and 1+0. I have 3 ATA hard drives and two optical drives can they be fitted to SATA connectors?"
Yes but it will Be fiddly and expensive.
" I have an AGP graphics card will this fit a PCI Express motherboard?"
" Lastly I have four PCI cards including sound etc but the motherboard has 1 x PCI Express x16, 2 x PCI Express x1, 3 x PCI. Can I use these for my existing cards?"
You can just use the 3 X PCI slots, so one will not work.
You would be better off not going for a bundle but to pick which cpu you want to use and build a different motherboard around this.