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.
Many spreadsheet users take advantage of the database features in Microsoft Excel when working with their spreadsheet data. Simple search, sort and filter functions are available using the Data menu within Excel. Microsoft Access is a full-featured, relational database that is compatible with Microsoft Excel.rovide a name for the file when prompted. Click File, Get External Data, Import and select the Excel format. Locate your spreadsheet subdirectory and import your spreadsheet into Microsoft Access.