Acey James Bunch
Microsoft Corporation
February 2000
ApplIEs To: Microsoft® Access 2000
Summary: Third in a serIEs of three articles, Advanced SQL builds on the concepts covered in the Fundamental and Intermediate articles, this time focusing on SQL syntax that is most often found in a multi-user environment. If you''ve read the previous two articles in an effort to become a well-rounded SQL user, this article will provide the final tools you will need to accomplish your goal. (24 printed pages)
Download AcAdvSQL.exe
Introduction
Advanced SQL Defined
The Multiuser Model
Jet vs. MSDE
SQL Coding Conventions
Advanced Data Definition Language
VIEws
Procedures
Managing Security