You will need some form of video capture device to transfer and convert the analog tapes into digital format. Then some software to edit it. Lots of choices out there, just type "video capture" into a google search.
I want to edit my (boring) vacation and other VHS camcorder tapes into something more interesting and I'm going to buy a new computer and need to know, aside from a large hard drive and lots of ram what other features and software I need. Not trying to be a pro, just have a little fun.

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic