Be sure you have the serial connection set to 9600, 8 data bits, no parity, 1 stop bit and no flow control.

If you are still having problems, check your serial cable by connecting it to your PC and looping back pins 3 and 4 on the other end of the cable.  You can use a bent paper clip to do this.  Once you have pins 3 and 4 connected to eachother, everything you type in hyperterminal should appear on the screen.  If this happens, it means your cable and PC serial port are OK.  Then remove the paper clip and connect the cable to the switch.  It should work.

That worked!  The cable tested okay.  No luck with the Console port on my switch.  Is there a way to test the port?

From a Google search, it looks like that Belkin cable is a straight through.  Dell requires a crossover (or null modem cable).  Here is one from the Dell website that will work.

My belkin cable says is has "crossed null-modem" wiring design.

The part number is: F3B207-10  Do I need something different?

This should work.

So another problem could be that the previous user changed the baud rate of the switch.  Try all the different baud rates.

After pressing and holding the reset button I can establish a connection, however now the text is just gibberish.  Odd letters and such.  Any suggestions?

giberish indicates that the baud rate is wrong.  Try different baud rates until you get the correct one.  9600 is the default. 

and your terminal program emulation set to VT100

Are you sure it is pins 3 and 4, when I do this nothing happens but when I loop pins 2 and 3 I get the suggested feedback.

You are correct.  It is pins 2 and 3 and not 3 and 4..