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

Рет қаралды 42,941

3 жыл бұрын

In this video, I will cover the pros and cons of Microsoft Excel and Microsoft Access. Which one is better? When should you use each one? Which should you use to manage your data? What's the final verdict?
Marc from Akron OH (a Gold Member) asks: I just started a small business and I can't decide whether I want to use Excel or Access to manage my customers, contact, orders, inventory, and so on. I don't want to use off-the-shelf accounting software like QuickBooks because I do have some unique record-keeping needs for my business. I've been using Excel for years, but I hear Access is a lot more powerful. What do you recommend?
BONUS FOR CHANNEL MEMBERS:
Silver Members and up get access to an EXTENDED CUT of this video which covers additional examples. That video will show you how to import and link data from Excel into Access. This way your secretary can perform data entry in Excel and you can bring it into Access. I'll show you how to use an append query to automate the process of importing newly entered data in an Excel sheet. Then we'll go the other way. I'll show you how to link Excel to an Access table so your secretary can see your customer list, itinerary, or whatever else you have in your Access database. I'll show you a trick to refresh that link every time he opens the sheet.
MEMBERS ONLY VIDEO:
• Microsoft Access v Mic...
BECOME A MEMBER:
/ @599cd
LINKS:
Get on my Mailing List: 599cd.com/YTML
Export to Access to Excel: 599cd.com/acx19
Export to Excel from Access: 599cd.com/acd20
ADDITIONAL RESOURCES:
FREE Access AND Excel Level 1: 599cd.com/Free1
FREE Blank Customer Template: 599cd.com/FRL2
$1 Access Level 2: 599cd.com/1Dollar
TechHelp: 599cd.com/TechHelp
Twitter: / learningaccess
en.wikipedia.org/wiki/Microso...
products.office.com/en-us/access
microsoft.com/en-us/microsoft...
Email Me: amicron@gmail.com
support.microsoft.com/en-us/o...
KEYWORDS:
microsoft access, ms access, #msaccess, #microsoftaccess, access vs excel, excel vs access, when to use excel, when to use access, when excel is better, when access is better, data analysis, reporting, access v excel, excel v access, data storage, management, integrity, collaboration
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.

Пікірлер: 52

@rawanaldaaja9358 3 жыл бұрын

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

@599CD 3 жыл бұрын

Thank you!

@mubeezimicah5678 3 жыл бұрын

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 3 жыл бұрын

You got it. :)

@DutchDiederik 3 жыл бұрын

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 3 жыл бұрын

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

@mastermindrational1907 5 ай бұрын

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

@599CD 5 ай бұрын

Thanks

@ZahidKhan-mb6oc 3 жыл бұрын

Great comparison and analysis..

@599CD 3 жыл бұрын

Thanks!

@teejayare2980 2 жыл бұрын

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 2 жыл бұрын

Sounds great!

@captainkeyboard1007 3 жыл бұрын

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 3 жыл бұрын

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

@captainkeyboard1007 3 жыл бұрын

@@599CD You are welcome.

@faithopara3949 3 жыл бұрын

Thanks very much for this video I appreciate

@599CD 3 жыл бұрын

You are very welcome

@davidortega2102 Жыл бұрын

Great video

@kossiviaglee2997 3 жыл бұрын

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 3 жыл бұрын

Already done: 599cd.com/Split

@vostykodhiambo9864 2 жыл бұрын

Amazing learning zone, thumbs uo

@599CD 2 жыл бұрын

Thank you 🤗

@stanTrX 6 ай бұрын

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 6 ай бұрын

Very true!

@ap74249 Жыл бұрын

Thank you

@599CD Жыл бұрын

Welcome!

@Abdulaziz-el4jm 3 жыл бұрын

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

@599CD 3 жыл бұрын

You are welcome!

@carlrigefsky9193 3 жыл бұрын

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

@599CD 3 жыл бұрын

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 3 жыл бұрын

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

@ignaciorivero6838 3 жыл бұрын

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

@rajputhabhishekrairai8285 2 жыл бұрын

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

@599CD 2 жыл бұрын

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.

@fahadalsweleh6542 3 жыл бұрын

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 3 жыл бұрын

Not sure this is possible in Excel without significant programming.

@fahadalsweleh6542 3 жыл бұрын

@@599CD Is it possible in access?

@599CD 3 жыл бұрын

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 3 жыл бұрын

@@599CD thanks

@Kiuci 3 жыл бұрын

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

@anujsangal3886 2 жыл бұрын

Woww

@599CD 2 жыл бұрын

Thx

@santiagobarrero186 Жыл бұрын

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

@599CD Жыл бұрын

599cd.com/ask

@jerrydellasala7643 2 жыл бұрын

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 2 жыл бұрын

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