Easing Into SQL

by Jonathan N
This Article talks about how difficult of a task it might be to master SQL. In the article they show us how to use the query design grid to create SQL statements and then how to run the statements in the immediate window to debug them. First the author, Susan Harkins speaks about building a SQL statement in the query design grid.  We as users are very likely to create errors and typos, so Susan recommends us to let Access do most of the work for us. Access produces an equivalent SQL  statement for every query. To begin, You first need to build a query like any normal query by clicking create query in the toolbar. You then need to drag fields from the field list to the grid, build relationships, add criteria. Once you have completed the queries you can now click the view button and choose SQL view and Access will display the query equivalent SQL statement. Then you can highlight the statement and copy it to a module.  Now Susan wrote about how we can Debug a SQL Statement in the Query Design Grid. Chances are statements won’t run correctly the first time after making changes from  the design grid to a module. There is a short list available in the link below that will help pinpoint the problem. After completing the tasks, you can run the statement by clicking the Run button on the toolbar.

 

This Article was good source of education to Access SQL. I learned to use the query design grid to create  SQL statements and then how to run the statements in the immediate window to debug them. This article had a lot to do with what we are currently learning about. Especially how out second project is understanding and working with My SQL server.

Susan Harkins (March 20, 2011) Easing Into SQL

Retrived From: http://www.pcmag.com/article2/0,2817,34162,00.asp