Thankfully, Dell now uses standard ATX power connections on their motherboards.
The one component that you never want to skimp on in a computer is the power supply. Good clean power is necessary for constant usage and efficiency in a computer. Buying a cheap power supply risks the chance of the power supply going out and taking the rest of the system with it. The PSU manufacturers that I recommend are:
Corsair, Antec, and Seasonic. PC Power and Cooling make solid units as well. Other PSU manufacturers that are worth looking at include Enermax, OCZ, Silverstone, and Coolermaster.
Since you're looking at the 400-500W range, why not get aim higher to help future proof your system? There aren't many upgrades that will require a massive amount of power for your system. I'm assuming that you don't have one of those dell slimline systems. You are stuck with an older technology, but socket 775 processors still have some life left kicking in them. For a PSU look for 80+ certification for power efficiency and reliability. I personally prefer modular cables, but people argue that adding points of resistance along the path of power decreases efficiency. Since I build computers, modular power supplies help and honestly, the power loss isn't that drastic imho.
Antec Earthwatts 500W 80+ Bronze Certified
http://www.newegg.com/Product/Product.aspx?Item=N82E16817371035
Seasonic 500W 80+ Bronze Certified
http://www.newegg.com/Product/Product.aspx?Item=N82E16817151080
Seasonic 460W 80+ Gold Certified
http://www.newegg.com/Product/Product.aspx?Item=N82E16817151099
PC Power and Cooling 500W 80+ Bronze Certified
http://www.newegg.com/Product/Product.aspx?Item=N82E16817703025
That's just to give you an idea. Some are quite expensive, but in my opinion worth it if you want to protect your investment. In general look for 80+ certification and an active PFC.
For the video card, how intensive do you plan to get and what are you using it for?
I like eVGA and XFX for their double lifetime warranties. Your card is always protected unless the company goes out of business like BFG.
GTS450 budget and requires a 400W minimum power supply
http://www.newegg.com/Product/Product.aspx?Item=N82E16817151099
The GTX460 is a bit more and for the money i'd say get the 450.
ATI/AMD also offers their Radeon cards at a slightly lower price point than NVIDIA chips
XFX Radeon HD 5750
http://www.newegg.com/Product/Product.aspx?Item=N82E16814150448
Or for even lower budget cards:
XFX GT240
http://www.newegg.com/Product/Product.aspx?Item=N82E16814150451
eVGA GT240 SuperClocked
http://www.newegg.com/Product/Product.aspx?Item=N82E16814130531
XFX Radeon HD 5570
http://www.newegg.com/Product/Product.aspx?Item=N82E16814150474
XFX Radeon HD 4670
http://www.newegg.com/Product/Product.aspx?Item=N82E16814150449
Look around that site and find what best suits you. I don't know what you are upgrading from or what your price point is. Some cards also have pre-overclocked versions. The manufacturer will overclock the base card for you and ensure that it is stable for retail use. Overclocking is when you take the base performance of a card and increase it via clock timings or multipliers.
Hope this helps!
BTW, if you didn't know already, NVIDIA and AMD/ATI are the two main rival graphics cards on the market. NVIDIA tends to have better performance, but at a higher price. AMD/ATI tend to have slightly less performance at a lower cost. The choice is up to you.