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

Chapter 23. Working with Structured Quer... > Understanding the Role of SQL in Acc...

Understanding the Role of SQL in Access 2000

This chapter describes Structured Query Language (SQL), the grammar of the language, and how Access translates queries you build in its Query Design view into Jet SQL statements. An SQL background helps you understand the query process and design more efficient queries. You need a basic knowledge of SQL to use the subquery and UNION query capabilities and for many of the applications you write in VBA. Simple examples of SQL are presented in other chapters in this book. These examples—usually figures that illustrate an SQL statement written by Access—demonstrate what occurs behind the scenes when you create a query or a graph.

Following are the new SQL reserved words introduced by Access 2000's Jet 4.0 database engine, ActiveX Data Objects (ADO) 2.1, and the ActiveX Data Extensions (ADOX) 2.1:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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