For reference, here's the tools I use at work for Software (and Webpage) Development:
Visual Studio .NET Enterprise Edition (better database and SQL Server support) - Explained above. It has Visual Basic, Visual C#, and Visual J#. What's the difference? One person said (and I quote), "It's like going from gear shift (C++/J++) to automatic (C#/J#)!".
SQL Server 2003 - This is the database server we're moving too (called migrating). We were using MS Access 2000. It's a more powerful SQL-based database engine.
Frontpage 2003 - Personally, I cringe at the thought of this one, since I like Dreamweaver better, but the top execs want all Microsoft products. Even the new webpage editor who was hired used Dreamweaver before she got her job here. (That's the job I was offered at first).
Crystal Reports - This is the report generation engine. It's used for making reports from the database.
Adobe Photoshop - The standard image editor. Mostly for cropping and adjusting contrast for images for Intranet slideshows. (everyone likes the slideshows I made over the summer, now they're demanding more! It used to be 1 page with 30 images and text. Poor design.)
Visual Interdev - An old Visual Basic scripting tool we used to use before moving to .NET.
MS Access 2000 - Another database program that's on its' way out.