:: Introduction
:: Database principles
:: Tables
:: Queries
:: Data security
:: Glossary
:: Resources
:: Student Files
:: Contact
:: Back to Main Site
:: Site Map

QBE

The query above is a query by example. The code that was generated by Access by creating this query in design view is as follows :

SELECT BOOKS.title, BOOKS.price, BOOKS.price, BOOKS.isbn
FROM BOOKS
WHERE (((BOOKS.price)>100)) OR (((BOOKS.price)<10))
ORDER BY BOOKS.title;

When you create a query in query Design view as shown in the above figure, Access builds the equivalent SQL statements behind the scenes for you. You can see the command by switching to the SQL view from the view drop down list. The SQL statement constructed can also be edited in that mode as well. When you run the query you will see the output in Datasheet view.