Great video, Mr. CLZ! I've been the Access Developer for my job for the last few months now since I know VBA pretty well... thought this was a good video to help me get started on understanding SQL.
Infact, I lost interest in Access until I learnt SQL properly. I'm an Advanced Excel user, with ability to use VBA comfortably. After learning SQL, Access is now a breeze.
Dear Sir, when we migrate access database table to SQL then i have faced first of all with date type and 2nd I have face some complication with multiple dropdown selection items. kindly guide us about these issues.
Some of these queries you "eliminated" aren't really eliminated; they are just moved from SQL in a UI exposed Query object to SQL embedded in another object. This cleans up the Navigation Queries UI but scatters the same queries in other, more opaque, places. This solves one set of issues but is not without its own headaches. ("What did I do with that query? Haven't I solved this before somewhere?!?") If your only goal is to reduce the number of queries in the Navigation pane, one other option worth considering is "Hide in this group" for the queries you don't want to see in the Navigation pane.
Hello Richard, how to create a table with field name and set field name to certain default value? CREATE TABLE tbl_NewStudents (student_id AUTOINCREMENT, student_name varchar(50) DEFAULT 'John'). Somehow the DEFAULT setting is not working. Please help.
@@599CD well, thanks for your response. But actually, I mean that I need to connect access with SQL Developer because I need SQL editor for SQL coding.
Dam! Best teacher i ever come across👏
Great video, Mr. CLZ! I've been the Access Developer for my job for the last few months now since I know VBA pretty well... thought this was a good video to help me get started on understanding SQL.
Great to hear!
Infact, I lost interest in Access until I learnt SQL properly. I'm an Advanced Excel user, with ability to use VBA comfortably. After learning SQL, Access is now a breeze.
Exactly! :)
How to find the SQL for a book table cause im not fonding it
Dear Sir, when we migrate access database table to SQL then i have faced first of all with date type and 2nd I have face some complication with multiple dropdown selection items. kindly guide us about these issues.
Some of these queries you "eliminated" aren't really eliminated; they are just moved from SQL in a UI exposed Query object to SQL embedded in another object. This cleans up the Navigation Queries UI but scatters the same queries in other, more opaque, places. This solves one set of issues but is not without its own headaches. ("What did I do with that query? Haven't I solved this before somewhere?!?") If your only goal is to reduce the number of queries in the Navigation pane, one other option worth considering is "Hide in this group" for the queries you don't want to see in the Navigation pane.
A valid argument. Thanks for sharing.
Awesome, thanks!
You bet!
Hello Richard, how to create a table with field name and set field name to certain default value? CREATE TABLE tbl_NewStudents (student_id AUTOINCREMENT, student_name varchar(50) DEFAULT 'John'). Somehow the DEFAULT setting is not working. Please help.
599cd.com/Ask
😀Nice video, waited for long.
Thanks
Much obliged
Welcome
How we can connect ms access with SQL developer
Access SQL Server Online: 599cd.com/SQLOnline
@@599CD well, thanks for your response. But actually, I mean that I need to connect access with SQL Developer because I need SQL editor for SQL coding.
Can u help me to creat database for our patients plsss
Sure: 599cd.com/ACB1
2:00 lmao its Kirk Hammett and James Hetfield
I don't get it. :/
@@599CD the second guy is named kirk james, and kirk hammett and james hetfield are the metallica's guitarists, a weird coincidence of name selection