Check this article

http://www.fmsinc.com/microsoftaccess/dataanalysis/versus-excel.html

Thank you Professor Kumar

Thank you Dr Aparna

Definition

Microsoft Excel is a spreadsheet application by Microsoft. It deals with the tabular data by using spreadsheets.

Access is primarily a database program from Microsoft. It is used to collect, manipulate and sort data.

Main Purpose

Microsoft Excel: For spreadsheets and financial calculations

Microsoft Access: For storing and manipulating large amounts of information

Structure

Microsoft Excel: Similar to paper spreadsheets

Microsoft Access: Consists tables, queries, forms, reports, modules and macros

Flexibility

Microsoft Excel: Comparatively more

Microsoft Access: Comparatively less

Data Model

Microsoft Excel: Non-relational or flat worksheets

Microsoft Access: Multiple Relational tables

Data Storage

Microsoft Excel: Comparatively less

Microsoft Access: Comparatively more

Learning

Microsoft Excel: Easy

Microsoft Access: Difficult

Testing

Microsoft Excel: Difficult

Microsoft Access: Easy

Advantages

Microsoft Excel:

• Easy to use and implement
• Ideal for creating one time analysis
• Easy to generate custom output

Microsoft Access:

• Data structure and normalization through multiple tables
• Scalability: adding more records is free
• Data and Referential Integrity
• Queries and Reports
• Automation through Macros and VBA Modules

Microsoft Office suite

Microsoft Excel: Included in all basic editions of Microsoft Office suite.

Microsoft Access: Included in the Professional and higher editions of Microsoft Office suite or sold separately.

Programming concepts

Microsoft Excel: Not required

Microsoft Access: Required to exploit most of the features

Thank you Dr. Harry

Wonderful submission

Following

Interesting question following

Following Dr Harrys answer