Microsoft Access vs Microsoft Excel: Which is Better? When to Use Each. Data Management or Analysis?

[@rawanaldaaja9358]

I'm from middle east I saw a lot of people how teach Microsoft Office programs..believe me you are the best 👌

[@599CD]

Thank you!

[@mubeezimicah5678]

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.

[@599CD]

You got it. :)

[@hben2011]

So, conclusion for small business to use both: use Access for your business general data flow and extract data into Excel for certain visualization and analysis purposes.

[@DutchDiederik]

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.

[@599CD]

Definitely don't keep important passwords in an unsecure spreadsheet that other people can get access to. Agreed.

[@captainkeyboard1007]

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.

[@599CD]

I'm flattered to be your "favorite show." Thanks. :)

[@captainkeyboard1007]

@@599CD You are welcome.

[@kossiviaglee2997]

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!

[@599CD]

Already done: 599cd.com/Split

[@carlrigefsky9193]

Are you taking into consideration Power Query in your analysis? Some Power Query features make EXCEL more robust.

[@599CD]

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.

[@mubeezimicah5678]

I suppose these must be a way to automate power query from Access.

[@ignaciorivero6838]

@@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

[@santiagobarrero186]

Couldn't you manage relations in Excel through power query like in Access?

[@599CD]

599cd.com/ask

[@stanTrX]

Thank you Richard. Seems to use these together depending on your needs. Edit : but i think excel online is pretty useful and very fast to share and considering custom view option you can filter for yoursefl without disturbing others etc

[@599CD]

Very true!

[@jerrydellasala7643]

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.

[@599CD]

Yeah, but that's like strapping a jet engine on a shopping cart.

[@mastermindrational1907]

Had to ‘thumbs up’ this, so helpful-cleared the confusion I had for these

[@599CD]

Thanks

[@teejayare2980]

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 :)

[@599CD]

Sounds great!

[@faithopara3949]

Thanks very much for this video I appreciate

[@599CD]

You are very welcome

[@rajputhabhishekrairai8285]

Excel or access which is good for analysis and interpretation of data

[@599CD]

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.

[@vostykodhiambo9864]

Amazing learning zone, thumbs uo

[@599CD]

Thank you 🤗

[@davidortega2102]

Great video

[@ZahidKhan-mb6oc]

Great comparison and analysis..

[@599CD]

Thanks!

[@ap74249]

Thank you

[@599CD]

Welcome!

[@anujsangal3886]

Woww

[@599CD]

Thx

[@fahadalsweleh6542]

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

[@599CD]

Not sure this is possible in Excel without significant programming.

[@fahadalsweleh6542]

@@599CD Is it possible in access?

[@599CD]

Sure. You can set up user logins with Access. You can then completely control what they can do. I cover this in my Security Seminar. 599cd.com/security

[@fahadalsweleh6542]

@@599CD thanks

[@Kiuci]

In Excel is super easy to do it... just keep the cell locked and password protect the workbook

[@Abdulaziz-el4jm]

Finally, a comprehensive answer about the difference between excel and access .. thanks

[@599CD]

You are welcome!

[@carlocalingasan998]

Excel has power query. Pretty much makes Access redundant.

[@599CD]

I disagree 100%. Each has their own uses. Only someone who doesn't know Access would call it redundant.

[@navjotsingh2251]

@@599CD I agree. In fact, power query shows that it works very nicely with any sql database including access. They both complement each other.