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 refers to this type of collection as a table. In Access terms, a database is a collection of all the tables, queries, forms, reports, macros, and modules that compose a complete system. Relational refers to concepts based on set theory.These concepts are covered in Chapter 10, âRelating the Information in Your Database.â.n this chapter, you learn what a relational database is. You then explore all the types of objects available in Microsoft Access. You are exposed to tables, relationships, queries, forms, reports, and modules.