What are the differences between Microsoft Access and Excel. Why would you use one as opposed to the other?
Different programs
These are two totally different programs. Microsoft Access is a database program while Excel is a spreadsheet program.
You would use Access to collect, manupilate and sort data. The primary use of excel is to create financial spreadsheets. Excel has some limited capabilities to sort data but its primary function is to create financial spreadsheets.
With Excel you can create extremely complicated financial "what if" scenarios where you can change some variables and get a good look at the financial consequences. It is an extremely powerful spread sheet. It does have some sorting capabilities but you would not want to try to create and maintain a complex database in Excel.
With Access you can collect, sort and manupliate data. For example you could do a data base on a large number of employees or members of a club, storing all the personal information. Then you could ask the program to give you just those that fit in any set of parameters. For example, employees with over ten year service, or employees in a certain state, division, zip code. Access can be used for any application where there is a large amount of data and you want the ability to sort it by different criteria.
Comments
Haha. I was gonna make a hub on the same thing, but looks like it's unneccessary now :)
There are at least two hubs with this title, and this is the better one. As of the time I read it, it had a hubscore of 81. I've been working with both tools for the last 10 years, and have come across any of a number of situations where one tool quite clearly was better than the other. Name and address lists are almost always better in Access, while the need for large numbers of formulas is often best in Excel. Good hub!
Steve
Thanks for you comment.
Access is good for huge informations as you can use vaidation rules which means data integerity.
very good answer
Excel is only for small amount of data, but Access can be used even for enterprise wide information system and can be hooked up with other database softwares like Oracle, SQL server and others to query data from them through an ODBC driver.
very good idea!!!!!!!!!!!! thank's a lot!
Today I have a Interview. This Answer Is Very Useful For Me. Thanks A Lot!!!!!!
thanks for sharing this .. this is very helpful to me
nice answer and good logic
thank you for making things easier for student.
thanks for your service...
correct result about data base and Microsoft access.
very nice answer
VERY LOVE
Both are different
this was helpful to me, thanks a lot
super exam
try to find many differences between Ms Accese and Spread sheet
thanks
Violette DeSantis 4 years ago
John,
Great answer. I was going to answer this as in my database days I was always "thrilled" to receive data in a spreadsheet that was better served in a database structure.
It still amazes me the misconception people have that Excel can be used instead of a database. If you want to set up some data fast in Excel do so; but I highly recommend importing it to a database when time allows.
Great Hub!