Is it interesting to combine Acess with Excel

[GUILHERME_MAYERHOFER]

I´m new hear, but i consult this Forum for some time already. But this is my first post. I have a model that is 70 MB and my stockholder thinks that it would be better to buy a software.
I already get in contact with a thew Suppliers but what they offered i could do in Excel. Coudn´t see a clear advantage on using the software.

My question is, if the problem is size, which makes the worksheet take some time to calculate and to save, would Acess help me that ? I could input all information in tables and import the information i need and work with it in the Worksheet.

I don´t know Acess well to say that would be acomplished. Just started to study it but i think it´s a hole new world and i don´t know if it´ll help.

 

[Joe4]

Welcome to the Board!

In a nutshell, Access is a relational database program. So, if you have a lot of data that you are relating to other data in Excel (using VLOOKUPS, INDEX/MATCH, etc), that may be a key that what you really have is a relational database which would work better in a relational database program like Access. You can often do those sort of things in Excel, but they often tend to be clunky and cumbersome (as that is not really what Excel was intended for).

There are various article out there that talk about making the decision to use Access vs. Excel. Here are a few, but you can find lots of other ones with Google Searches:
http://beekeeperdata.com/posts/2016/01/28/excel-vs-access-what-are-the-differences.html
https://support.office.com/en-us/ar...our-data-09576147-47d1-4c6f-9312-e825227fcaea
https://blogs.technet.microsoft.com/hub/2010/01/15/where-should-i-put-my-data-excel-or-access/

Note that sometimes that answer may be a blended approach, using both.

 

[GUILHERME_MAYERHOFER]

Welcome to the Board!

In a nutshell, Access is a relational database program. So, if you have a lot of data that you are relating to other data in Excel (using VLOOKUPS, INDEX/MATCH, etc), that may be a key that what you really have is a relational database which would work better in a relational database program like Access. You can often do those sort of things in Excel, but they often tend to be clunky and cumbersome (as that is not really what Excel was intended for).

There are various article out there that talk about making the decision to use Access vs. Excel. Here are a few, but you can find lots of other ones with Google Searches:
http://beekeeperdata.com/posts/2016/01/28/excel-vs-access-what-are-the-differences.html
https://support.office.com/en-us/ar...our-data-09576147-47d1-4c6f-9312-e825227fcaea
https://blogs.technet.microsoft.com/hub/2010/01/15/where-should-i-put-my-data-excel-or-access/

Note that sometimes that answer may be a blended approach, using both.

--**--**--**--**--**--**--**--**--**--**--**--**--**--**--**--**--**--**--**--**--**

Thanks for the quick reply Joe. I think i´ll follow though with my studies to use both Acess and Excel then. Because my final purpose is to display the information in accounting reports and dashboards. but the info behind it could be stored in Acess.

 

[Joe4]

That's not a bad approach to take. Access definitely handles storing large amounts of data better than Excel, but Excel provides for "prettier" graphics (charts, graphs, etc) than Access.
Good luck!