What is the difference between Excel and Access?

4 replies
Which of them allows deleting duplicates, checking for duplicates, pulling particular info such as the number of employees
#access #difference #excel
  • Profile picture of the author seoannie
    The basic differance between Excel and Access is that excel works on data analysis and Access works on data management. Excel is easy to generate sharable output and Access works on database management wiyh multiple users.
    {{ DiscussionBoard.errors[11137665].message }}
  • Profile picture of the author techugo
    Excel and Access are two applications from the software giant,excel is also a lot easier to learn since it is meant to be used by a lot of people.Microsoft Excel is a spreadsheet application by Microsoft. It deals with the tabular data by using spreadsheets.
    {{ DiscussionBoard.errors[11138422].message }}
  • Profile picture of the author ernestrategos
    Microsoft Excel is a spreadsheet application. This type of software is suited for dealing with data through columns/rows. It communicates well with other applications in order to present data.

    Microsoft Access is a database application that deals with structured data. It outputs it through different means.

    Both can be used to analyze data. In Excel you can use formulas to achieve what you want.
    {{ DiscussionBoard.errors[11145442].message }}
  • Profile picture of the author Quick Learners
    An Excel table contains rows and columns of cells in a flat file. Each line in the table contains one record. In Access you can store data in more than one table and create relationships between table data in order to perform complex queries. With Access you also can link to data in larger, external SQL (structured query language) databases.
    {{ DiscussionBoard.errors[11146188].message }}

Trending Topics