Access 2000 et le Microsoft Jet SQL
2006-10-20 #sql
Une liste d'articles intéressants sur MSDN à propos de l'utilisation du language SQL avec les bases de données Access 2000. À lire, imprimer et voir s'ils existe des trucs dans le même style pour les dernières versions d'Access.
Fundamental Microsoft Jet SQL for Access 2000
This article discusses the basic mechanics of using Jet SQL to work with data in an Access 2000 database. It also delves into using SQL to create and alter a database's structure. If you're new to manipulating data with SQL in an Access database, this article is a great place to start. (21 printed pages)
Intermediate Microsoft Jet SQL for Access 2000
Second in a series of three articles, Intermediate SQL builds on the concepts covered in the Fundamental SQL article and gives a much more detailed picture as to what can be accomplished with Microsoft Jet SQL in Access. For users and developers seeking to expand their understanding of Structured Query Language as it is used in the Microsoft Jet Database Engine, this article is designed to be the next logical step. (38 printed pages)
Advanced Microsoft Jet SQL for Access 2000
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)
Mise à jour :
- quelques notes à propos de ces 3 articles sur : http://www.chat11.com/Microsoft_Access_SQL
- un tutoriel en français sur Le langage SQL dans Access