Query free database

[MajP]

Which I want to learn, so please guide

If you got a specific question please post, but asking us to randomly guide you means nothing. There are lots of resources if you need to learn SQL or VBA.

If you are trying to learn how to write SQL then writing it in vba is not necessary. Instead of using the designer simply go to SQL view and type it in. I recommend you read every example here. If you go through this, you will be away ahead of most people.
SQL Tutorial (w3schools.com)

 

[isladogs]

I agree with @MajP and was going to suggest exactly the same site for learning SQL.
In the query designer, change to SQL view to see how the SQL is constructed though Access often adds lots of largely unnecessary brackets.
You may also find my sql to vba converter useful whilst you are learning ... SQL to VBA & Back Again - Mendip Data Systems.
This is designed to assist with creating SQL for use in VBA procedures
It can also help you convert back to SQL for use in a saved query

You might also find these two articles from my website useful: Query Join Types and Optimising Queries

Also be aware that you cannot use dB.execute or DoCmd.RunSQL on SELECT queries.
Use a query def in code or a saved query for those

If you get stuck on particular points, ask in another thread.

However do bear in mind the cautionary points made by others such as @MajP and @The_Doc_Man

 

[Pat Hartman]

SQL and VBA are different languages. One has nothing to do with the other. In a RDBMS such as SQL Server or Oracle, VBA is not even available.

There is not a significant speed advantage to one or the other but there are reasons as everyone has mentioned where one method is better than the other for certain circumstances.

 

[isladogs]

Pat
I'm not sure if that first line was aimed at me or the OP.
If it was aimed at me, then I think you have misunderstood the purpose of the converter.
I've added a couple of sentences for clarification but it might help more to look at the link provided

 

[Pat Hartman]

It was aimed at the poster. I didn't notice the link to the converter. If you created it, I'm sure it is as useful as all your other stuff.

 

[isladogs]

Thanks for the reply. Apologies if I was being over-sensitive.
For info, the converter is an enhancement of an utility originally created by Allen Browne

 

[Pat Hartman]

Thanks I'll look at it.

 

[Pat Hartman]

I downloaded it and I get a runtime error. Don't have time to research.

Also, as a matter of personal preference, I hate databases that open to popup forms, probably because it is because I just downloaded them and the code isn't trusted and the pop up prevents me from getting to the trust button. So, I have to close the app and reopen it with the shift key so I can trust it and then reopen it.