(No Narration) Link to a MS Access Database from MS Excel + Automatic Update in Excel upon opening
3.3 هزار بار بازدید -
5 سال پیش
-
Please note that this is
Please note that this is the first video that I ever made and I did not narrate because I wanted to get a feel for the audience first. However, it is brief and simple enough where narration isn't needed.
This is a quick demonstration for how to link to a MS Access database table in MS Excel and automatically update any data changes for consistency. In other words, if new data are entered or changed in MS Access, this will be automatically updated when you open your Excel spreadsheet as well.
This can helpful for when you want to use data from an Access database, but want to use functions in Excel. In some situations for example, Excel has some native functions that Access doesn't, such as statistical tests like Chi-Square calculations or T-tests.
5 سال پیش
در تاریخ 1398/12/24 منتشر شده
است.
3,363
بـار بازدید شده