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

In this video, I'll teach you about the basics of SQL and how to use it in Microsoft Access. We'll see how to edit the SQL of an Access Query, how to modify the Record Source of a form, and the Row Source of a combo box.

Ari from Hollywood, Florida (a Platinum Member) asks: I have a billion queries in my Access database. Is there any way to consolodate those so the list is a little more manageable? Most of them are just variations on the same theme, like different ways to sort customer lists.

Silver Members and up get access to an Extended Cut of this video. Members will learn how to manipulate SQL using VBA code. We will change a form's RecordSource property and a combo box's RowSource property directly using VBA. This will allow us to make dynamic events by using click events in our forms.

MEMBERS VIDEO:

BECOME A MEMBER:

LEARN MORE:

LINKS:

SUGGESTED COURSE:

OTHER COURSES:

FREE TEMPLATE DOWNLOADS:

ADDITIONAL RESOURCES:

KEYWORDS:
microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, Access SQL basic concepts, vocabulary, syntax, SELECT statement, Microsoft Access SQL, Microsoft Access SQL reference, Can you use SQL in Microsoft Access, Is SQL same as Microsoft Access, Is Access good for SQL, How to Use SQL with Microsoft Access, SQL View, structured query language, why you should learn SQL, sql language vs. server

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.

[marcuslee]

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.

[digitalmasters]

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.

[nathaleeellis]

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

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

[tittyathou]

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.

[rosemarieannsantiago]

Can u help me to creat database for our patients plsss

[mohammedalsarraj]

How we can connect ms access with SQL developer

[canudonut]

2:00 lmao its Kirk Hammett and James Hetfield

[outby]

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.