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.
A Brief MS Access Tutorial. A spreadsheet program is a terrific tool for maintaining and calculating small sets of information. Microsoft Excel is easy to understand, create column names, enter your data, create formulas, and you're on your way.You can sort, filter, and format the data quickly and easily.he value any database can provide is to store related information in one place, and then let you connect various different things together (sometimes called entities in database speak). You store one version of the truth for any given thing, like a client, a DVD, or an order.