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!
@zakeerrg30102 жыл бұрын
Excellent. The way you explained with minimal talking.
@banxify3 жыл бұрын
Just query the data you need in access and export to excel.
@archanaaa25143 жыл бұрын
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?
@rabidfollower3 жыл бұрын
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.
@qowalapundit2 жыл бұрын
Great video. However I couldn't find the link from Microsoft you mentioned. could you put it in description or comment,please?
@auditradley2 жыл бұрын
But doesn't power query power pivot in exel gives the same? you can make connections the same way
@saaqo79812 жыл бұрын
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.
@StAlKeRsification2 жыл бұрын
Access is for large table
@manuelugaldeultreras8422 жыл бұрын
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.
@JazminMortimer3 жыл бұрын
Thanks for this tutorial! Really helpful.
@kaaa34852 жыл бұрын
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
@newvision75043 жыл бұрын
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
@wsitech3 жыл бұрын
At least much more easily than Excel, you're right.
@LaVa-xy9sm3 жыл бұрын
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?