Please enable JavaScript.
Coggle requires JavaScript to display documents.
Microsoft Access and Excel (Excel (Cons (It is not meant for storing large…
Microsoft Access and Excel
Access
Pros
Queries and Reports
Multi-user environments
Data structure and normalization through multiple tables
Handling large amounts of data
Data and Referential Integrity
Combining data from multiple sources
web-based applications
Excel
Pros
Displaying data in charts and graphs
Performing on-the-fly analysis
easy to store data
perform numerical calculations
analysis toolkit
integrate data
format cells
analyzing data using complex, multi-step functions
adjust layouts
Access
Cons
Need to learn how to create databases
Data Visualization is More Advanced
Multi-user limited
Cannot Place Fields Anywhere
Excel
Cons
It is not meant for storing large pieces of data
You cannot run reports on it
lot of practice
It is not a database
It is not meant for modifying large pieces of data
It is very functional