SQL for Microsoft Access

Cecelia L. Allison9781556220920, 1556220928

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.