Over at the excellent FileMaker Magazine site run by one of my all time favorite FileMaker gurus, Matt Petrowsky, they've posted two great introductory videos about FileMaker 7.
An Introduction to FileMaker Pro 7
An Introduction to FileMaker Pro 7 - Part 2
If you are wanting to see what all the excitement is about in a live demo, you must see these two cool 40 and 50 minute videos. Matt provides running commentary while you watch him working with FileMaker Pro 7. Double-click if you need to pause and then double-click again to unpause. Matt does a great job - he's taught standing room only sessions at the FileMaker Developer conference for years and is the author of Scriptology.