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

Part V: Appendix > An Introduction to SQL

An Introduction to SQL

VBA isn’t the only language Access understands. Structured Query Language (SQL) is the de facto language of relational databases, and as such, Access also speaks SQL. Specifically, Access speaks a dialect known as Jet SQL. Although you’ll often hear Jet SQL called Access SQL, SQL speaks to Jet, not Access. This appendix covers general information about Jet SQL as well as syntax instructions and a short language reference. This short appendix is meant to serve as a simple introduction to the most common and basic statements and certainly isn’t inclusive of all SQL statements and rules.

SQL is the industry’s standard support language for relational databases. There are a number of relational databases on the market and each has its own version of SQL. As mentioned, Access uses Jet SQL. Originally, SQL was called Structured English Query Language, pronounced sequel. Because of a legal conflict with the name, the language was renamed to SQL, pronounced “s-q-l”.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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