Access Queries
Printer Friendly Page
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