HomeОбразованиеRelated VideosMore From: Programming

75. SQL UPDATE Query (Programming In Access 2013)

69 ratings | 23573 views
SQL UPDATE Query in "Programming in Microsoft Access 2013". Hosted by Steve Bishop. In this free beginner video tutorial series Steve will be going over Database Development in Access, creating the User Interface, creating SQL queries, and coding the backend of the application in Visual Basic for Applications (VBA). Click here for the full playlist of "Programming in Access 2013" http://www.youtube.com/playlist?list=PLYMOUCVo86jEeMMdaaq03jQ_t9nFV737s Click here for the Work Files of this series: https://github.com/Xipooo/ProgrammingInAccess2013
Html code for embedding videos on your blog
Text Comments (15)
aRrOwHoN (7 months ago)
Hey this website helped me do my sql update statements quickly http://smallhustle.com
Alberto Fresneda (2 years ago)
can someone tell me what sql is and what it has to do with ket?
Alberto Fresneda (2 years ago)
+Alberto Fresneda oh, say nuttin
Alberto Fresneda (2 years ago)
+Alberto Fresneda u can use sql to make ket still
Alberto Fresneda (2 years ago)
Hi Steve, i rate this video still
Vexhosable (2 years ago)
+Alberto Fresneda shut up
peter skaanning (2 years ago)
hi Steve first thanks for all your videos, but I have a question about linking to an excel file, I have an excel file that are continuous updated the data in this I am using in my DB in access now to my question, is there a way to update my Db with only the new data from my excel file an delete the data that isn't in the excel file any more?
Programming (2 years ago)
No, I don't think I do, but I'm sure there are some tutorials out there that talk about importing Excel.
peter skaanning (2 years ago)
+Programming Hi Steve are there one of your videos there cower that ?
Programming (2 years ago)
+peter skaanning Your best route would probably be to import the entire excel into a new table, then do an insert query where the value doesn't already exist, then delete the table you created.
Cyrus Wong (3 years ago)
Thanks :)
Scout Jhay (3 years ago)
can you make a video regarding vba programming that uses a form to add delete update a table???
Scout Jhay (3 years ago)
thanks..your the best
Programming (3 years ago)
That's what we did in the Recordset videos earlier in the video series.
Laith Hameed (3 years ago)
This is so great and really easy to understand THANKS .........

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.