You can think of Excel as a collection of flat file databases. Combining Excel and Access can make use of the best parts of both applications.
"Microsoft Excel is great at a lot of tasks, but it has limits as a database manager. If your Excel data worksheets are beginning to get out of hand, it may be time to call in a little help from Access."
Creating Access Forms To Work with Excel Data (Jim Uomini is a long-time trainer, courseware designer, technical writer, newsletter editor, and support manager. He currently manages the help desk for in-store systems at The Sharper Image.)