Page 1 of 11PREVNEXT

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.

About this course

This course includes:

  • One self-paced lesson.
  • A short test at the end of each lesson; tests are not scored.
  • 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.

Goals

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.


Confused about when to use Access or Excel? That's understandable. On the surface, both programs look alike. After all, they store data, and you can enter that data in a grid of cells, right?

So how do you choose between the two? One way is to answer a few simple questions about how you want to organize your data, and about related issues such as the amount of data you want to store and manage.

Your answers to those questions can help you get more done in less time, so keep an open mind!

To learn more about this course, read the text in Goals and About this course, or look at the table of contents. Then click Next to start the first lesson.

Page 1 of 11PREVNEXT