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

Chapter 6. Importing and Linking Data > A Word About Open Database Connectivity...

A Word About Open Database Connectivity (ODBC)

If you look under the hood of Access, you’ll find that it uses a database language called SQL (Structured Query Language) to read, insert, update, and delete data. SQL grew out of a relational database research project conducted by IBM in the 1970s. It has been adopted as the official standard for relational databases by organizations such as the American National Standards Institute (ANSI) and the International Organization for Standardization (ISO). When you’re viewing a query in Design view, you can see the SQL statements that Access uses by choosing the SQL View command from the View menu or by selecting SQL View from the View toolbar button.

Article 1 on the companion CD, “Understanding SQL,” provides more details about how Access uses SQL. The Appendix, on page 1223, provides details about installing and managing ODBC connections on your computer.




PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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