SECTION I: Preparing the ComputerI'm using mostly Microsoft products. They're powerful but potentially expensive. Thankfully, Microsoft has taken pity on us poor university students, so there are some great offers for students.
Since most everyone has Windows, and Visual Studio 2010 Express is free, the only issue that most will find here is getting a copy of Office 2007/2010. If unavailable, this can be skipped without too much loss.
1. What is neededTo fully follow along without much translation, the following software will be necessary:
-Windows XP SP3, Windows Vista SP2,
or Windows 7.
-Microsoft Office 2007
or 2010
-Microsoft Visual Studio 2010
Also plan on using:
-SQL Server 2008
-MASM
-Eclipse
2. Where to get itDISCLAIMER: Listed prices and sources are provided without warranty. These represent what I currently believe to be accurate at the time of posting, but I make no guarantee on the accuracy of this information. Please be careful to observe all license agreements.
a. Windows 7
-If you're a student, you can get Windows 7 Professional for $65 at
Win741.com.
-If you're a student, your university may have an
MSDNAA program which will provide you with Windows 7 Professional for free.
-If you're a student, you can buy the
upgrade to Windows 7 for $30 through the
Ultimate Steal program.
-You can try buying Windows 7 online or in a store.
b. Microsoft Office
-If you work in a corporation, you may be able to download Office 2010 Professional Plus through Microsoft's Home Use Program. (Ask the IT department if your company participates in the Home Use Program.) It costs about $10 to get the best version (Professional Plus) through this program.
-If you are a student, you can get Microsoft Office 2010 Professional Academic through the
Ultimate Steal program for $80.
-You can try buying Office 2010 online or in a store.
c. Microsoft Visual Studio 2010
Version order: Express, Professional, Premium, Ultimate-If you're a student, you can download Visual Studio 2010 Professional through
DreamSpark.com for free.
-If you're a student, your university may have an
MSDNAA program which will provide you with Visual Studio 2010 Premium for free.
-You can download Visual Studio 2010 Express for free
from Microsoft. This is the most basic version, and you'll notice that it comes in four parts.
-You can buy Visual Studio 2010
from Microsoft (but it can be expensive).
I'll touch on the other three - SQL Server, MASM, and Eclipse - when I get to them, if I do. They're not bad on the price. SQL Server offers a 180-day trial so that you can learn (or free offers for students), MASM is free, and Eclipse is free. Just no point in installing them now.
3. Setup1. After installing the necessary software, be sure to check for and install Microsoft patches.
2. Enable the Developer tab in Excel (
for Excel 2007,
for Excel 2010).
4. AlternativesAlthough I suspect that the setup I'm using is a fairly good one, there are probably other good alternatives. I will not recommend any here as I cannot vouch for them, but I'm sure that they can be found.
Since 90% of computers use Windows, I'll assume that it's available. Since Visual Studio 2010 Express is free to everyone, that shouldn't be a problem. The biggest issue may be with Office.
If Office 2007/2010 isn't available, 2003 may work alright for the most part if you know how to translate between the versions. OpenOffice and other suites will not work for the purposes of this thread.
5. Deep breathFinding and setting this stuff up wasn't fun. But I think that it's proven worth-while.