Excel vs Access | Pros and Cons | The Introduction to MS Access Course

No video

Excel vs Access | Pros and Cons | The Introduction to MS Access Course

Рет қаралды 51,257

Chester Tugwell

Күн бұрын

Пікірлер: 19

@Mariusz803 2 жыл бұрын

Finally the presenter that speaks clear English, minimal talking, no added fluff, right to the point with relatable examples. A lot of tutorials could learn from this. Thanks for the video.

@catepilarr Жыл бұрын

Thats what I also wanted to say, thanks for putting it into words!

@zakeerrg3010 2 жыл бұрын

Excellent. The way you explained with minimal talking.

@banxify 3 жыл бұрын

Just query the data you need in access and export to excel.

@archanaaa2514 3 жыл бұрын

But in excel also we can split table by adding different sheets right.. I don't know what is major difference between Access n excel?

@rabidfollower 3 жыл бұрын

Excel allows free-form data entry, but Access demands structure -- database structure that was set by the industry decades ago. Databases are used by pretty much everything you see on the Internet that lets you search for things. When you search Amazon for products, you are using its database. When you Google stuff on Google, you are searching its database. The reason to use databases are performance and data capacity. The ability to search the entire Internet and get results in split second can only be possible with databases. Excel doesn't have the "engine" for such capabilities and is just a glorified notepad by comparison -- which is fine, if that is what you need.

@navjotsingh2251 Жыл бұрын

Access is way better for relational data and tables. It also uses sql, which is a very nice way to create,query,manipulate and join tables.

@qowalapundit 2 жыл бұрын

Great video. However I couldn't find the link from Microsoft you mentioned. could you put it in description or comment,please?

@auditradley 2 жыл бұрын

But doesn't power query power pivot in exel gives the same? you can make connections the same way

@saaqo7981 2 жыл бұрын

I have never used Access, maybe it's more efficient and reliable. but we can make relationships in Excel "Power Pivot" and get the same results I believe. So I don't see any difference between Excel and Access in this example

@simonmaersk Жыл бұрын

@@saaqo7981 Excel is not for storing data, it's for data analysis and calculation. Access is a proper relational database for storing and manipulating data.

@StAlKeRsification 2 жыл бұрын

Access is for large table

@manuelugaldeultreras842 2 жыл бұрын

I made an excel database and the links break every time and computer shuts down unexpectedly. I need to keep date enter into word files or pdfs that open as I open a link. Which is better for my case, excel or access. On excel all I need it to display the information and link the information that I see to the file.

@JazminMortimer 3 жыл бұрын

Thanks for this tutorial! Really helpful.

@kaaa3485 2 жыл бұрын

Thank you so much for the video. I have a question. I use my access database daily, but today when I close my form that has subforms, I get the message "No current record". I don't know what has happened, it was not doing till yesterday. The first form has 2 subform. I used to get two of the message "No Current Record". when I deleted the first subform, I only got one message but when I deleted the second one, I did not get none. I have been working with database for 15 years, I never got this message until yesterday. one more thing, I also get it when I hit add new record. did microsoft access change the coding? Will you please, help solve this problem? Thanks in advance

@newvision7504 3 жыл бұрын

In Access. Relationship can be formed between two or more tables. Access is more reliable to create complete searchable , data software. Access works on this four concepts. 1. Forms 2. Tables 3. Queries 4. Reports

@wsitech 3 жыл бұрын

At least much more easily than Excel, you're right.

@LaVa-xy9sm 3 жыл бұрын

Hi, I have a list of students in a class and some of them need to change the level, time or classroom name. so we need to select the names and choose the level, time or classroom name and click go, Do you have that video?