Choose between Access and Excel

Access or Excel?

Confused about whether to use Access or Excel? Learn how to choose the right program for your needs.

Start course button

About this course

This course includes:

  • A Quick Reference Card you can take away from the course. Links in the Quick Reference Card take you to information about getting started with both programs.


After completing this course you will be able to:

  • Choose the right program — Microsoft Office Access 2007 or Microsoft Office Excel 2007.

  • Know whether to use a relational or flat data structure.

Before you begin

You'll need a bit of experience with Excel, an open mind, and a willingness to try something new.

Topics in this course

  1. Right questions, right program

  2. Relational means data in multiple tables

  3. The advantages of relating

  4. Flat keeps it all together

  5. To relate, or not to relate?

  6. More questions, more clarity

  7. Solid reasons to use Access

  8. Solid reasons to use Excel

  9. Quick reference card

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!