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.
User review
Excellent fundamentals explanation
As somebody new to both Access and SQL, I found this to be my best reference for getting started. It covers the basics and does a great job. You cannot perform advanced objectives without a solid understanding of the fundamentals.
Each chapter has a series of self-test questions to make sure you have mastered the necessary concepts for that chapter. (and the answers are in the back)
There's also quite a bit of good quick reference material in the back for frequently used SQL keywords (for Access) and general database terminology.
I've found it to be a great book and I highly recommend it.
User review
Excellent Access Primer
This book is an excellent primer for the SQL novice. It is well organized and offers an excellent exposition of Microsoft's version of the SQL language. There is just on big problem; it is just about impossible to download the book's companion file offered on the Wordware site. This problem is a serious flaw in an otherwise outstanding book.
