SQL is used to retrieve data from a database. SQL is simply a computer language (closely resembles English language) that database programs (DBMS) or applications like Microsoft Access understand and MySQL. The knowledge of SQL is important because every query in MS Access is first translated to its equivalent SQL before it is being process by the database engine. Understanding how SQL works can help you to create better queries and makes it easier for you to fix, debug or manipulate a query in order to obtain your desired output.
step by step guide to learning sql in access and mysql databases

WHAT IS SQL?
SQL as an acronym means “Structured Query Language”. It is a computer language for working with sets of facts and the relationship between them. Relational Database Management Systems (RDBMS) such as MS Access, MySQL, etc. use SQL to work with data.

Like many other computer languages, SQL is an international standard language recognized by standard bodies such as ISO and ANSI.

This is part 2 of chapter 6 of the Free Online Access Tutorial Series at Microsoft Tutorial website. In this part, I will explicitly explain how to learn SQL in Relational Database Management Systems (RDBMS) software like Microsoft Access 2016, 2013 and other lower versions.

In the previous chapter at http://www.microsofttut.com/2017/04/how-to-build-and-manipulate-parameter-queries-in-access.html, I explained How to build advanced queries and action queries in MS Access. Also see the full tutorial course content of this Microsoft Excel Tutorial Series at http://www.microsofttut.com/p/microsoft.html.

When you use SQL, you must use the correct syntax or statement. A syntax or statement is a set of rules by which the elements of a language are correctly combined to achieve a particular result. SQL syntaxes are based in English syntax and uses many of the same elements as Visual Basic for Application (VBA) syntaxes.

NOTE:

You really need to be grounded in MS Access Advanced Queries before you can flow in SQL because the latter is more complex and needs a deeper understanding of its pre requisite which is Advanced Queries. I advise to revise the previous chapter (chapter 5 – Advance Queries) before you continue.

WHERE TO TYPE SQL STATEMENTS IN MS ACCESS
Microsoft Access has SQL environment (view) or interface where you can type SQL statements directly without having to first write in design query view.

To Access the SQL view in MS Access:
1. Launch MS Access and open previously created database or create a new one if you wish.
Click http://www.microsofttut.com/2017/04/learn-sql-in-ms-access-mysql-databases.html to study full tutorial with screen to screen images

You should have stated categorically u want to sell ur E-book