SQL Queries in Access

Using SQL Queries

by Linda Quinn

Close Window

Access Queries create Structured Query Language (SQL) statements.

SQL is used by many databases. It does not belong to Microsoft.

Building queries in Access will create SQL statements.
When you create queries, you should look at the SQL statement it creates.

Query Types

Select Query

SELECT * FROM tblCustomers
SELECT * FROM tblCustomers WHERE Name=SMITH

Make-Table Query

SELECT CustomerID, FirstName, LastName, CustStatus
INTO NewTable
FROM tblCustomer
WHERE CustStatus="ACTIVE"

Append Query

INSERT INTO tblCustomers ("Name, Address, City, State, Zip)
VALUES ("Joe Customer", "123 Main Street", "New York", "NY", "00110")

Update Query

UPDATE tblCustomers SET ZipCode="60060" WHERE City="Chicago"

Delete Query

DELETE * FROM tblCustomers

=================================================================
This content was created by Linda Quinn of LQNet.

See http://www.lqnet.com for a great collection of articles on this and other topics.

=================================================================

====================================================================
Want an expert to help with your project? LQ Systems, Inc. Business Solutions
====================================================================

Using SQL Queries

Query Types

Copyright © 2006-2009, LQ Systems,Inc. All rights reserved.