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.
Spreadsheet Databases. Spreadsheets store information using rows and columns that correspond to the records and fields used by database software such as Oracle, IBM DB2, SQL Server or MySQL. With a spreadsheet, however, your data is stored and accessed from your own desktop PC rather than from a remote, database server.arly users of software such as VisiCalc, MultiPlan and Lotus 123 recognized the power of spreadsheets to create business simulations, models or what if scenarios.