1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. 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...

  3. 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?

Discussion in 'The Lounge' started by PP3321, Mar 21, 2018.

  1. PP3321

    PP3321 Active Member

    Messages:
    371
    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...
    ThrottleWorks likes this.
  2. Chihiro

    Chihiro Excel Ninja

    Messages:
    5,052
    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.
    ThrottleWorks, Hui and PP3321 like this.
  3. Marc L

    Marc L Excel Ninja

    Messages:
    4,257
    Hi !

    « When is it better to use MS Access instead of Excel? »
    In 2 words when hearing database and multi-users
  4. PP3321

    PP3321 Active Member

    Messages:
    371
    ThrottleWorks likes this.

Share This Page