Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

SQL etc

Posted Jul 26, 2001

Beginning SQL Programming: Pt. 2 - Page 3

By DatabaseJournal.com Staff

Front Ends

In this book we will use different front ends in chapters in order to help you become more versatile. The differences are not very great; the SQL statements remain the same regardless of the front end. In Chapter 2 we will talk you through setting up various combination of front ends and back ends as well as showing samples of code.

The syntax of how each front end sends those SQL statements may vary occasionally. Likewise, each front end has its own syntax or tools for handling the data that is returned when a SQL statement asks for information. We will point such differences out where they may occur.

Access

Microsoft's desktop database uses SQL in many places.  You can write and store queries as SQL statements. You can use SQL to define the source of a report or form. One option puts the actual SQL statement into the report as the value of the Record Source property. A second option stores the statement in a query and uses the query name as the value for the Record Source. SQL statements are also valid sources for list boxes on Access forms. Although Access never requires a user to employ SQL, in many places SQL can be used instead of Access object names.

The query grid contains a very powerful feature for students of SQL with Access experience. You can use the drag and drop interface of the grid to create a query, the same as you have already done many times in the past. But you can then click on View/SQL and see that visual interface expressed as a SQL statement, ready to cut and paste. Similarly a query can be created as a SQL statement and then viewed as a grid. At any time the query can be run to check the results.

You may be familiar with the Access Query Grid view:

Access Query Grid View
(Click picture for full size view)

We can click on Menu:View | SQL View to see the same request written as a SQL statement:

Access Query as SQL
(Click picture for full size view)



SQL etc Archives

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




Latest Forum Threads
SQL etc Forum
Topic By Replies Updated
MySQL rollback UAL225 0 August 21st, 09:56 PM
Complex Search Query Galway 0 May 20th, 10:04 PM
change collation at once supercain 2 May 15th, 06:18 AM
SQL Features, tools and utilities question Neomite 1 April 10th, 09:13 AM


















Thanks for your registration, follow us on our social networks to keep up-to-date