i like your summary, "use both". i normally use both. with Access as my main application, i write commands in Access to for example draw graphs in excel (Access-Excel integration). This helps in that novice Excel users don't have to struggle to say draw a graph from scratch.
Had to ‘thumbs up’ this, so helpful-cleared the confusion I had for these
You answered all my basic questions regarding this topic. Thank you! Very valuable info.
One point regarding the domain name/password comment you made towards the end. It’s bad practice from a security standpoint to store passwords in a spreadsheet. Use a password manager like LastPass, instead.
Definitely don't keep important passwords in an unsecure spreadsheet that other people can get access to. Agreed.
Love the videos, you really have taught me a lot! Thank you.
Once I get the small project that I’m working on complete, I would like to enrol in your VBA courses.
Thanks once again :)
Great video
I really like this comparison video. I appreciate your conclusion because I like both but you help to see clear. Please let me just ask you this favor: Would you please make a video on how to make Access database available for multiple simultaneous users. Just an example with simple database example with two or three computers in a video. Thanks so much in advance!
This video is my favorite show. I am becoming an experienced user of Microsoft Access. I do use Microsoft Excel for heavy-duty number crunching. I use Microsoft Access for information management, indexing and filing. I do use Access more than Excel, but use Excel to work more with numbers. I think that I made an upgrade when I switched from Microsoft 365 to Microsoft Office 2019.
Finally, a comprehensive answer about the difference between excel and access .. thanks
Are you taking into consideration Power Query in your analysis? Some Power Query features make EXCEL more robust.
I'm aware that PQ does make Excel more robust. This is more of an analysis of both programs at their core. There are add-ons for Access too, to give it more robust features. I certainly appreciate your comment though. It's perfectly valid.
@@599CD Thank you very much for the course. If PQ makes Excel more robust and has some of the pros in Access, when is it better to use PQ when working with large spreadsheets? Thank you
Excel or access which is good for analysis and interpretation of data
Depends on the amount of data. Like I say in the video, Access is better for LARGE datasets. Excel is good for analyzing small amounts.
Couldn't you manage relations in Excel through power query like in Access?
Thanks for your presentation I have question: - can we make password for one cell For example: I have students and I want fill their information but one field for grade I want to fill it with password so no one before or after can fill it without password
thanks
Sorry, but your two disadvantages of Excel are not correct. Excel can provide data structure and relationships between tables of data using the Data Model.
This is not to say I disagree with your basic reasons for using either - Access can provide a MUCH better user interface, and can be easier for reporting when many tables are involved.
However the Data Model in Excel provides structured tables with data types, relationships between fields in tables, very powerful and easy reporting using Pivot Tables and Pivot Charts, and can be used for large data sets of millions of records using those Pivot reports.
Also, Excel Web allows powerful multiple user use.
Excel has power query. Pretty much makes Access redundant.
I disagree 100%. Each has their own uses. Only someone who doesn't know Access would call it redundant.
@@599CD I agree. In fact, power query shows that it works very nicely with any sql database including access. They both complement each other.
I'm from middle east I saw a lot of people how teach Microsoft Office programs..believe me you are the best 👌
Thank you!