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.
Access records are free for modification at any time. The above image shows Access (top) and Excel (bottom) for comparison. Note, when using Access each individual record is given a specific ID number â the first column â to allow you to sort, filter and query your entire database. And your database is just that â a digital store of information.