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.
When you link to an Excel worksheet or a named range, Access creates a new table that is linked to the Excel data. If you want to add, edit, or delete data, you make the changes in Excel, and refresh (or requery) the data in the Access table. However, you cannot edit the contents of the table in Access.. Publish Excel workbooks to Excel Services, and display and interact with data by using the Microsoft Office Excel Web Access Web Part on a Web Part Page. 4. Import (connect) data into an Excel workbook from OLAP servers, SQL Server and Access databases, and flat files.