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.
Use Access data in Excel. 1  To link to Access data and get information, you'll need to select Tools-Add-ins and check AccessLinks Addin and MS Query Add-in. 2  Then, from anywhere on your worksheet, you can select Data-Get External Data: 3  This will start MS Query.  Then select the database you want to use: