Excel is a powerful business tool.

What tasks come to mind when you think of the program Excel? Lists, databases, a way to keep track of customers information? Excel is good for these things, but so much more! I have done some research recently on the differences between Excel and Access. This has remained somewhat of a mystery to me over the years, because I have chosen not to try to learn Access. Excel has done the trick for me so far. But now comes the time when I need to tackle this task – time to stretch my brain a little more. I thought I’d share what the differences are between Excel and Access. Here is an article I found giving an explanation between the two:
Microsoft produces two different products—Access and Excel—that many people use interchangeably. However, each has its own purpose and one may be better for your needs than the other. While both cost the same, they are vastly different. Knowing those differences can help you pick the right one for your needs.
.Purpose
The most important difference between Microsoft Access and Microsoft Excel is the purpose. Access is a relational database management system, while Excel is a spreadsheet. Access manages large amounts of data, and Excel does math.
Availability
Both Access and Excel may be purchased separately. If you want to buy an Office package from Microsoft, Excel is available in the Home, Student and Professional packages, while Access is included only in Professional.
Relational Data
If you need to create relationships between your data, Access is the only choice. Because it uses only flat files, Excel has limited functionality and cannot make the connections that Access can.
Ease of Use
Excel is more user-friendly and intuitive than Access, with a GUI that resembles Word, a commonly used program.
Size
Excel can only handle up to 15,000 records. Access is meant to handle thousands of records, all related through multiple tables.
Querying
Access is meant to create calculated queries, making connections based through a “wizard” or through user programming. Excel does not have the ability to do so, although it can create charts, graphs and pivot tables.
Calculations
Excel is meant to handle numerical data and run equations. Access is capable of doing so, but that is not meant to be its main function.

Read more: Difference Between Microsoft Access & Excel | eHow.com http://www.ehow.com/facts_4842302_difference-between-microsoft-access-excel.html#ixzz1CodNlWTn

I will be posting some of the fun, flexible and powerful things you can accomplish using Excel.  It is a great tool for home or business.   If you don’t want to miss any useful tips, be sure to subscribe to my blog.  Thanks for stopping by and reading.  Until next time…Cindy

Advertisements

2 responses to this post.

  1. Cindy

    Thank you for posting the two different Microsoft products Access and Excel. I am familiar with Excel and putting up spreadsheets however had no idea about Access. Will definitely check out this program.

    Regards,
    Jane

    Reply

    • I’m glad you got some useful information from the post. I am on a journey to understand and learn Access. Like you I’m familiar with Excel and stopped there, but would love to understand how Access functions more like a database. You can put in multiple fields of information and then sort it to come up with customizable reports or snapshots of information. Just need to get it into my head. Thanks for stopping by…Cindy

      Reply

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: