Tape cassettes - easiest way is tape machine headphone jack to Mac Line in socket with a standard mini phono plug (3.5mm)
Vinyl records - depends on the player. Most ordinary record players will need a pre-amp to use with the line-in socket. Cables required will be dictated by the particular equipment.
You can get USB record decks built for the purpose.
QuickTime will do the job, but I use Audacity for more versatility with editing, noise reduction etc.