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.
Both Excel and Access are capable of doing a lot of things that the other can do. Both can store data. Both allow you to manipulate data. Access is primarily for lists of data, such as names and addresses, while Excel mainly deals with numbers.
Excel is composed of spreadsheets similar to traditional paper spreadsheets. Each spreadsheet is made up of cells that can be manipulated, and the text in each can be formatted to the user's liking. Access is composed of tables, queries, forms, reports, macros and modules. It is more difficult to extract data from Excel spreadsheets because you need built-in formulas to look up information.