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

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

Access is for large table

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

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.

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.

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

Excellent. The way you explained with minimal talking.

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

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?

Don't use Excel as a database, it'll cause you no end of headaches when you populate it with lots of data. I've been a developer of SQL based applications for 20 years and have had numerous customers ask me to convert their unnormalised Excel spreadsheets to Acces or SQL Server. It's a serious and time consuming pain in the arse.

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?

Thanks for this tutorial! Really helpful.

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