dimanche 26 janvier 2014

Excel Vs. Access

By Jason Larrsohn


Microsoft Excel is a crucial tool for people in both the private and business sectors. It provides a wide range of individuals with a large number of tools for compiling data, whether it's in number or word form. At some point, most people will encounter a spreadsheet in their travels.

Personally, I've done more work with Excel than Access. I'm also more of a Superman fan than a Batman fan. So Excel will be Superman and Access will be Batman. Excel can do quite a bit. It's true that it is best for more straightforward data management: lists, calculations, spreadsheets, summaries, and more static data. This is how Superman takes care of business. Fly in, boom bang and he's done.

On the other hand, Access is better at more complicated queries, relational data (meaning linking information from one source to another), charts and graphs. Data changes frequently and is often accessed and altered by more people. This is the same way Batman works. He is more complicated. He's got all his gadgets that are constantly updating and changing. He has sidekicks. He takes a more clever approach to problems.

So it all depends on what you want. Consider what type of information you would be working on. For example, if you just need a worksheet to keep records of previous sale data, you will probably want to go with Excel. If you need organized lists of names, dates, addresses, phone numbers, etc., Excel is a great resource for that. It is direct, organized, smart, and customizable.

However, if you work with data that changes frequently or if you need that information to be easily linked or associated with other information, access might be the best option for you. Especially if many people contribute data to the same worksheet, Access is ideal. It's got more "outside" connections, if you will.

But remember, both of these programs are powerful and can be made to do much of the same information. Just like our favorite superheroes. Both of them save their cities on practically a daily basis. They handle everything from small muggings to nuclear threats. They are both smart, careful, powerful, and get the job done. Batman is more ideal when it comes to technical things. Superman is better when it comes to more natural things.

The biggest part of a spreadsheet in Microsoft Excel is the data that goes into it. Without the data, it would be more practical for you to create your document within Microsoft Word. In Microsoft Excel, you have the ability to draw from data that's collected from many different areas. The more data that you have to work with, the more options you will have for what you can do within your spreadsheet.

Even if Access is more ideal for that kind of project, it's fine to stick with what you know. But if you like efficiency and learning new things, take a course from Microsoft Training Kuwait and get your Microsoft Certification Kuwait for both programs!




About the Author:



Aucun commentaire:

Enregistrer un commentaire