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

Chapter 5. Working with Queries > Querying with SQL

Querying with SQL

SQL is a flexible and powerful language that lets you specify precisely which records and fields you want to use in your query. Actually, you're working in SQL whenever you create a query! Access automatically translates your queries to SQL. To see the SQL source behind a query, simply open your query and choose View > SQL View.

This view shows you what actions Access has to take when it creates and runs your query. Because SQL is a very common feature of databases, viewing Access queries can help you understand SQL queries generated for other databases.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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