SQL for Microsoft Access

最新推荐文章于 2022-03-28 20:12:04 发布

topmvp

最新推荐文章于 2022-03-28 20:12:04 发布

阅读量476

点赞数

分类专栏： ACCESS 文章标签： microsoft sql access database structure insert

本文链接：https://blog.csdn.net/topmvp/article/details/2845365

版权

ACCESS 专栏收录该内容

35 篇文章 0 订阅

订阅专栏

版权声明：原创作品，允许转载，转载时请务必以超链接形式标明文章原始出版、作者信息和本声明。否则将追究法律责任。 http://blog.csdn.net/topmvp - topmvp
SQL for Microsoft Access unlocks the power of Structured Query Language (SQL) in Microsoft Access.

It guides the reader through step-by-step examples of creating a database in Microsoft Access using SQL script to create tables, add records to tables, and retrieve and manage records using simple to advanced data manipulation techniques including queries and views. The reader also encounters exam-ples of integrating SQL script into VBA and ASP code.

* Explore the relational database structure and the basics of SQL.
* Learn how to insert, retrieve, and filter records.
* Understand how table joins, unions, and subqueries are used to retrieve records from multiple tables.
* Learn how to use views and temporary tables.
* Discover how to prompt the user for information with parameter queries.
* Find out how SQL can be used to enhance Active Server pages.
* Test your knowledge through the end-of-chapter quizzes and projects.

http://rapidshare.com/files/52015435/1556220928.zip