• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 6. Locating Specific Information... > Creating SQL-Specific Queries

Creating SQL-Specific Queries

SQL (Structured Query Language) is a powerful database language used in querying, updating, and managing relational databases. For each query, Access automatically creates an equivalent SQL statement. If you know SQL, you can edit this statement, or write an entirely new one, to create new, more powerful queries. Access supports three kinds of SQL-specific queries: union, pass-through, and data-definition. Each of these query types fulfills a different need.

Create a SQL-Specific Query

In Query Design view, click the Query menu, and then point to SQL Specific.

Click Union, Pass-Through, or Data Definition.

Enter SQL commands to create the query.

Save and view the query.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint