Knox County. UT Extension serves the citizens of Knox County with educational programs in the areas of Agriculture, Family and Consumer Sciences, Community Resource Development, and 4-H Youth Development.
Microsoft Excel on the other hand is a spreadsheet program, it is usually used to display data and work out calculations in the form of tables and graphs, it also has a more integrated use of macros. So basically, Access stores data, Excel calculates and displays data.   ANS2:Access creates relational databases.
Choosing Between Spreadsheets and Databases. We are often asked by Microsoft Office power users whether, why, and when they should use Microsoft Access versus Microsoft Excel. Especially when they are very comfortable using MS Excel and don't understand the reasons why anyone would use MS Access or databases. Here's our perspective.