Microsoft Access SQL Tutorial. How to Use SQL With MS Access Databases. 5 Reasons to Learn SQL.

[@marcuslee2026]

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.

[@599CD]

Great to hear!

[@nyumbaniproject5296]

Dam! Best teacher i ever come across👏

[@navisalomi]

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.

[@599CD]

Exactly! :)

[@gaetanomaximus8650]

Awesome, thanks!

[@599CD]

You bet!

[@digitalmasters29]

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.

[@outby50]

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.

[@599CD]

A valid argument. Thanks for sharing.

[@tittyathou2987]

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]

599cd.com/Ask

[@projectmanagerkscadc6154]

😀Nice video, waited for long.

[@599CD]

Thanks

[@nathaleeellis]

How to find the SQL for a book table cause im not fonding it

[@moizrashid6373]

Much obliged

[@599CD]

Welcome

[@mohammedalsarraj9963]

How we can connect ms access with SQL developer

[@599CD]

Access SQL Server Online: 599cd.com/SQLOnline

[@mohammedalsarraj9963]

@@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.

[@canudonut]

2:00 lmao its Kirk Hammett and James Hetfield

[@599CD]

I don't get it. :/

[@canudonut]

@@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

[@rosemarieannsantiago895]

Can u help me to creat database for our patients plsss

[@599CD]

Sure: 599cd.com/ACB1