• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

When is it better to use MS Access instead of Excel?

PP3321

Active Member
Dear Chandoo community,

I want to ask your opinions or experience of switching to Access from Excel.
I want to know what was the main reason for switch.

Here is my situation:

1)Every day I have been adding 100 rows of data to excels manually
2)Now the worksheet contains 10,000 rows.
3)For duplicated values, I have Conditional Formating
4)I cannot enter values that are available in another worksheet.
There is vlookup to check

I am beginning to think I should start using Access as it seems to be less prone to error...

*I saw this post to understand advantage and disadvantge of Excel
https://chandoo.org/forum/threads/so-what-is-excel.33984/#post-202480

Thanking you in advance...
 
Excel's advantage is in it's portability, flexibility and it's data analysis/visualization capability.

Access is far superior for...
1. Managing relational data
2. Multi-User data entry
3. Managing data integrity (as opposed to flexibility)
4. Data loss prevention

Personally, I'd use Access for data entry/storage. Then Excel to report/analyze the data.
 
Back
Top